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.
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
149
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
455
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
160
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
547
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
166
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
477
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
520
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
338
views
asked 5 months agolg...
I need to construct a complex JSON which replicates the structure of API response using sql query, in order to compare both for testing purpose.
Can/will redshift support JSON functions (such as...
1
answers
0
votes
403
views
asked 5 months agolg...
We have a materialized view from a MSK topic with auto refresh on. We would like to delete rows that were ingested > 78 hours (see delete operation below). The DELETE SQL is syntactically correct but...
1
answers
0
votes
676
views
asked 5 months agolg...
The goal is to create a temp table with consecutive numbers from 1 to 25567.
I tried this SQL statements:
-- Create temp table
DROP TABLE IF EXISTS numbers;
CREATE TEMP TABLE numbers
...
1
answers
0
votes
210
views
asked 5 months agolg...