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 run an AWS Glue job where I transfer data from S3 to Amazon Redshift. However, I am receiving the following error:
```
Error Category: UNCLASSIFIED_ERROR; An error occurred while...
2
answers
0
votes
1289
views
asked 5 months agolg...
My redshift cluster has automatic snapshots which are being created. Is there a way for me to access the incremental data to the cluster ? I do not want to restore the cluster, I want incremental data...
1
answers
0
votes
289
views
asked 5 months agolg...
We have an SQL producing results with lots of NULL fields. The code contains almost 1800 lines with many subqueries but the outermost query is a **left outer join** of 2 subqueries (named **t_1** and...
2
answers
0
votes
269
views
asked 5 months agolg...
is it possible to conveniently mask all columns in a Redshift table? The example in the [docs](https://docs.aws.amazon.com/redshift/latest/dg/t_ddm.html#ddm-example) only masks one column but is there...
1
answers
0
votes
532
views
asked 5 months agolg...
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
490
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
169
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
445
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
153
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
466
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
172
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
567
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
430
views
asked 5 months agolg...