Questions tagged with Amazon Redshift
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hi,
I am trying to ran a simplest query on tommy_asin_v2 table, at bumblebee I found that it it belongs to the andes_ext.searchdata catalog:
But when I ran: select * from...
1
answers
0
votes
238
views
asked 10 months agolg...
Hi
We are using datashare to share data between 2 redshift clusters within the same account.
We started running into this started recently, no information regarding this on web or in aws docs.
Any...
1
answers
0
votes
685
views
asked 10 months agolg...
in TD we have -- CAST((CAST(FROM_TIME AS INTEGER) MOD 60) AS FORMAT '99') .
How to achieve the same in Redshift?
thanks
KN
1
answers
0
votes
199
views
asked 10 months agolg...
Hi all, I'm trying to change the subnets assigned to a Redshift Serverless Workspace. I submitted the changes successfully, but it's been a full 24 hours and the workspace is still in the...
1
answers
1
votes
404
views
asked 10 months agolg...
Is there a way in the QuickSight Pivot Table to display rows with no values? Using filler numbers, my organization has 100 unique Regions/Fields, and each active employee is aligned to supporting a...
0
answers
0
votes
93
views
asked 10 months agolg...
Hi AWS community,
I hope you're all doing well. I have a question regarding data management and best practices when using Amazon Redshift and S3.
Once data has been successfully imported into an...
1
answers
0
votes
432
views
asked 10 months agolg...
How can I refer item_id column when I create a model of time series forecasting in Redshift ML?
ERROR: One string column type referring to item_id is required for FORECAST [ErrorId:...
1
answers
0
votes
289
views
asked 10 months agolg...
Hi AWS, if I add `redshift-serverless:*` in the SCP does it change anything i.e.
1. Any public endpoint
2. Lack of support for vpc endpoints
3. Communication flow between AWS Managed service...
1
answers
0
votes
198
views
asked 10 months agolg...
I've been trying for a few hours to connect to my Redshift serverless database - I'm following steps on this page:
[https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html]()
I'm...
1
answers
0
votes
1122
views
asked 10 months agolg...
I read data from s3 using as follow.
```
sec_id_dyf = glueContext.create_dynamic_frame.from_options(
connection_type = 's3',
...
0
answers
0
votes
105
views
asked a year agolg...
We have been facing issues about responding to GDPR requests for the data stored in our redshift warehouse. Main issue is data stewards who are responsible for this are mainly business users and they...
1
answers
0
votes
307
views
asked a year agolg...
Hi,
We recently setup redshift serverless and loaded some small data (a few mb).
In the console, within the workgroup, when I click on "actions" --> Edit base RPU capacity", I can't go lower than...
2
answers
0
votes
704
views
asked a year agolg...