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,
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
119
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
341
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
355
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
180
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
90
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
84
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
446
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
149
views
asked 6 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
186
views
asked 6 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
245
views
asked 6 months agolg...
I need to create a aes encryption ECB UDF in the redshift. To achieve this, i have imported pycryptodome zip file in the S3 with the name Crypto.zip and create library in the redshift.
When i try to...
1
answers
0
votes
269
views
asked 6 months agolg...
Scenario:
Source table: Glue Data Catalog table **study** crawled from MySQL with columns:
* id (int),
* code (varchar),
* desc (varchar)
* and 2 other columns not used in the job.
Target table:...
0
answers
0
votes
101
views
asked 6 months agolg...