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.
I created glue catalog external schema on Redshift serverless .Both Glue and redshift are in same location .
----------------------
create external schema dojo
from data catalog
database...
0
answers
0
votes
169
views
asked 2 years agolg...
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
131
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
205
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
220
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
252
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
73
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
49
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
175
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
276
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
39
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...