Unanswered 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, I read about ANALYZE COMPRESSION and made this script to analyze and set the recommended compression for all tables, the idea is to run it at night once per month or every 15 days.
I set 3M rows...
0
answers
0
votes
39
views
asked 2 years agolg...
I have a Kinesis data Stream whose records I want to insert it in the AWS redshift with using AWS Glue.I created crawlers to bring source table and target table .They are working fine with .
The code...
0
answers
0
votes
128
views
asked 2 years agolg...
I am trying to load data from an EC2 instance into Redshift tables but cannot figure out how to do this using the copy command. I have tried the following to create the sql queries:
```
def...
0
answers
0
votes
201
views
asked 2 years agolg...
**Major Version (03/03/2022)**
We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region...
0
answers
0
votes
217
views
asked 2 years agolg...
**Major Version (01/19/2022)**
We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region...
0
answers
0
votes
251
views
asked 2 years agolg...
Hello Redshift team,
I am trying to understand as to why the query fails when a variable is introduced to it.
The below query expands date range, and returns the list. In the "date_list" CTE...
0
answers
0
votes
72
views
asked 2 years agolg...
My team is hoping to convert many of our numeric and date/time based columns to [az64 encoding](https://docs.aws.amazon.com/redshift/latest/dg/az64-encoding.html).
What I am wondering is if there is...
0
answers
0
votes
48
views
asked 2 years agolg...
**Major Version (11/15/2021)**
We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region...
0
answers
0
votes
173
views
asked 2 years agolg...
**Major Version (10/20/2021)**
We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region...
0
answers
0
votes
271
views
asked 2 years agolg...
Created an external table thru spectrum for loading 30 parquet files into redshift table using insert select but every time getting the below error. **None of the Dictionary tables give proper...
0
answers
0
votes
38
views
asked 2 years agolg...
Hey guys,
I stumble upon this error while creating Materialized Views.
Every second dbt job on Redshift cluster gets failed due to this error.
```
Database Error in model stg_uploads...
0
answers
0
votes
55
views
asked 2 years agolg...
Amazon certificates used to sign the Amazon Redshift ODBC drivers on Apple macOS will be rotated on September 4 2020. If you use driver versions 1.4.10 (AmazonRedshiftODBC-1.4.10.1000.dmg) or higher...
0
answers
0
votes
209
views
asked 4 years agolg...