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.
My workgroup shows a status of "Failed", and has done for a few days. I can still access the data in the Query Editor. I can successfully create a new workgroup, and the namespace associated with the...
0
answers
1
votes
255
views
asked 2 years agolg...
Hello,
Since the upgrade to version 3.4.7 from 3.4.6 of DMS. Some of our migration tasks are failing, only on some specific tables.
We migrate tables from AuroraMySQL, MySQL RDS and Postgres RDS...
0
answers
0
votes
218
views
asked 2 years agolg...
An architectural mismatch has often led to issue like -
When trying to connect through a dotnet application it fails with the following error message: "ERROR [01000] [unixODBC][Driver Manager]Can't...
0
answers
0
votes
181
views
asked 2 years agolg...
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
158
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
123
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
189
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
209
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
245
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
71
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
43
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
162
views
asked 2 years agolg...