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.
```
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
219
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
759
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
395
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
325
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
252
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
224
views
asked 6 months agolg...
Hi,
With the following query I am able to see the privileges on schema level and I see there also my configured roles (which are connected with Azure Active Directory groups)
```
SELECT DISTINCT
...
Accepted AnswerAmazon Redshift
2
answers
0
votes
128
views
asked 6 months agolg...
Hey, I have been trying to set up a connection between Airflow and redshift using redshift_default connection but I have been unable to do so. I am attempting to use the S3 to Redshift Operator to...
1
answers
0
votes
352
views
asked 6 months agolg...
Hey all, I have been trying to perform a simple S3 to redshift data push using an S3 source node and a Amazon Redshift target node.
I have been getting errors such as
'Failed to connect to IP...
4
answers
0
votes
370
views
asked 6 months agolg...
Is Identify Tables With Missing Statistics Query Resutl redshift_audot_health_check Meaningful?lg...
I executing the diagnostic queries for Redshift. The query below is the one for *Identifying tables with missing statistics*. The page discussing these queries, and this query specifically, is...
1
answers
0
votes
185
views
asked 6 months agolg...
Do you know what the minimum version you need to be on to use the new metadata_security system parameter in Redshift?
1
answers
0
votes
96
views
asked 6 months agolg...