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 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
174
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
585
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
434
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
174
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
495
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
561
views
asked 6 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
351
views
asked 6 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
430
views
asked 6 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
705
views
asked 6 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
218
views
asked 6 months agolg...
I'm trying to create redshift cluster from snapshot with the terraform configuration files unfortunately it has not well and getting following error.
Error: restoring Redshift Cluster (test123) from...
0
answers
0
votes
73
views
asked 6 months agolg...
IAM Identity Center to Redshift integration: Registered identity provider does not exist for AWSIDClg...
Hi there,
I am trying to integrate IAM Identity Center with Redshift. We manage Users and Groups from IAM Identity Center from Management account where the Redshift cluster exists in an OU account....
0
answers
0
votes
86
views
asked 6 months agolg...