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.
Hello everyone! The problem that I'm having is that I need for a stored procedure in redshift to return a temporary table. Not in the way described here...
Accepted AnswerAmazon Redshift
1
answers
0
votes
471
views
asked 5 months agolg...
Hello,
I found the queries which allows me to add users, roles and grant access to tables etc. However I want have a more automated process so we don't forget steps while e.g. dropping a user/role...
1
answers
0
votes
163
views
asked 5 months agolg...
I am encountering the following error while running my Node.js application to retrieve data using AWS Redshift Serverless.
"'ERROR: permission denied for relation...
1
answers
0
votes
427
views
asked 5 months agolg...
the data set is 2 Tera Bytes with 30Billow rows and 80 columns for 20 years history. our redshift cluster is 2 ra3.4xlarge
I have successfully loaded 5 years (1/4) of the data set in 6 hours
any...
Accepted AnswerAmazon Redshift
1
answers
0
votes
150
views
asked 5 months agolg...
I have an event bridge schedule that runs a redshift stored procedure. The call is failing but I'm not seeing any errors or anything.
When I run the stored procs manually they work.
So how can I...
2
answers
0
votes
458
views
asked 5 months agolg...
Hi!
I observe a strange behavior in Redshift when adding a time column to an existing table.
For example, the following works just fine, i.e. i can create a table with not null time column and...
Accepted AnswerAmazon Redshift
2
answers
0
votes
164
views
asked 5 months agolg...
I am using Redshift and trying to upload data from my local device through the Query Editor v2. I receive the error message "A staging Amazon S3 bucket is required and is not configured. Go to...
Accepted AnswerAmazon Redshift
2
answers
0
votes
554
views
asked 5 months agolg...
I have enabled logging for my AWS Redshift cluster and am able to see the UserActivityLogs in CloudWatch. The problem that I am having is that when a query has multiple lines, it is split into...
1
answers
0
votes
421
views
asked 5 months agolg...
All of my keys in super fields in external tables became **lowercase**.
Current result is
`{"id": 1, "super_field": {"camelcase":1,"uppercase":2,"lowercase":3}}`
Should be
`{"id": 1, "super_field":...
1
answers
0
votes
167
views
asked 5 months agolg...
Hello!
I am using Redshift Serverless and am having some difficulty with auto-complete. This understandably leads to tedious typing of queries and introduces unneeded typos.
We have several...
1
answers
0
votes
480
views
asked 5 months agolg...
Hi, we have a Zero-ETL integration setup running but without us changing anything it have now started a Resync of some tables. That is fine but the problem is that it stops in the middle of the resync...
Accepted AnswerAmazon Redshift
1
answers
0
votes
526
views
asked 5 months agolg...
I am running a Glue ETL job to load data from parquet file from S3 into Redshift table.
![Enter image description here](/media/postImages/original/IMrrvRKNfNQ0604h-FuKYtFQ)
I am able to get data...
2
answers
0
votes
340
views
asked 5 months agolg...