Questions tagged with Amazon Redshift

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...

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...

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...

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...

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:...

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...

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:...

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...

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...

I have a Redshift cluster currently configured with two ra3.xlplus nodes. I am going to vertical upscale the cluster from two ra3.xlplus nodes to three ra3.xlplus nodes. A planning assumption is that...

[updated] Resolved with this...

when we drop some table in a store procedure, redshift throw below error. After struggling searching on the internet, don't find any. please help. The strange is it only have this issue on dev env, ...