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.
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
233
views
asked 5 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
207
views
asked 5 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
109
views
asked 5 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
320
views
asked 5 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
340
views
asked 5 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
172
views
asked 5 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
74
views
asked 5 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
79
views
asked 5 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
405
views
asked 5 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
145
views
asked 5 months agolg...
Hey,
We have a Glue crawler crawling a series of CSVs in S3 and capturing this in a database. This is surfaced in Redshift via Spectrum Schema.
The problem we have is that in Redshift, the...
1
answers
0
votes
175
views
asked 5 months agolg...
Hey there,
I have a create table query with sortkey and distkey defined, the source data comes from s3.
The query looks like this
```sql
create table...
1
answers
0
votes
231
views
asked 6 months agolg...