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.
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
413
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
163
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
464
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
470
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
329
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
378
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
654
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
204
views
asked 5 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
69
views
asked 5 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
83
views
asked 5 months agolg...
```
CREATE temp table temp_table (
id INT,
name VARCHAR(50),
age INT,
city VARCHAR(50)
);
INSERT INTO temp_table VALUES
(1, 'John', 25, 'New York'),
...
Listagg function in all my pipelines stopped working this morning. Pipelines were written months ago.
The same error everywhere
ERROR: function LISTAGG(character varying, "unknown") does not exist...
1
answers
0
votes
195
views
asked 5 months agolg...