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.
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
392
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
322
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
249
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
221
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
126
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
348
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
363
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
183
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
94
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...
I am building a data pipeline to Load data into Redshift from an S3 data lake.
Data are stored in Parquet format on S3 and I would like to load them into the respective Redshift tables using an AWS...
1
answers
0
votes
469
views
asked 6 months agolg...
Hello, I am trying to use materialized views in Redshift, where I have a Zero-ETL integration configured from Aurora MySQL to Redshift. Since the destination Redshift database is completely read-only...
0
answers
0
votes
154
views
asked 6 months agolg...