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.
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
757
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
323
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
351
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
368
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...
Hi,
I am trying to configure a scheduled query using Redshift Query Editor V2. However, I am facing an issue where I am unable to view the schedule history as I am faced with the following permission...
0
answers
0
votes
87
views
asked 6 months agolg...