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 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
409
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
682
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...
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
84
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
203
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
725
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
386
views
asked 6 months agolg...
Hi all, I need to demonstrate lake formation data filters usage. What is the easiest way to query this data and show the difference caused by filters.
I have 2 roles accessible to my account. One role...
1
answers
0
votes
317
views
asked 6 months agolg...
Hey all, I currently have a data file in s3 which i am trying to output to redshift through glue visual studio. My data successfully got sent to redshift tables, but the amount field has changed the...
2
answers
0
votes
244
views
asked 6 months agolg...
I am trying to use an UDF Function in Redshift. and the IAM Role associated with it has `"lambda:InvokeFunction"` on all resource enabled.
However, when I tried to run the query :-
`SELECT...
1
answers
0
votes
217
views
asked 6 months agolg...