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!
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
482
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
530
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
342
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
412
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
684
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
213
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
71
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
84
views
asked 6 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
205
views
asked 6 months agolg...
Hi there,
I am trying to make Redshift accessible from AWS SSO page as a separate SSO application. We don't use any external Identity Provider and all users are managed from IAM Identity Center by...
2
answers
0
votes
730
views
asked 6 months agolg...
Hi all, I am trying to implement lake formation security on my data lake consisting of bronze, silver, gold zones in s3 and glue catalog tables. The gold zone data also exists in redshift tables with...
1
answers
0
votes
388
views
asked 6 months agolg...