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.
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
87
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
83
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
431
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
184
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
242
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
265
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...
If my environment is full of Apache Hudi integrating with EMR and Lake Formation, I found out that Hudi environment is not very friendly to be used by Redshift nor Athena. There are many advanced...
1
answers
0
votes
458
views
asked 6 months agolg...
i'm used AWS glue crawler data from S3 Bucket to Datacata log and using AWS redshift query but show error:
ERROR: Parsed manifest is not a valid JSON object. Detail:...
1
answers
0
votes
422
views
asked 6 months agolg...
Hello,
Here is my current situation where I need some help ;)
* I created user groups in Azure Active Directory and added users to it
* I connected AAD with AWS
* I have a redshift database with...
2
answers
0
votes
312
views
asked 6 months agolg...
On `Redshift 1.0.60353`, I'm getting the following error for a query that previously worked:
```
SQL Error [XX000]: ERROR: failed to find conversion function from "unknown" to numeric
```
According to...
1
answers
0
votes
1550
views
asked 6 months agolg...