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.
Hello community. We are observing a few issues in the Copy command from S3 to Redshift and need your advice.
PS: We're using Airflow for Orchestration and use the S3ToRedshiftOperator for the copy...
0
answers
0
votes
130
views
asked 10 months agolg...
When using Redshift Serverless `COPY` commands fail when copying into a table with non-null columns with default values. This can be reproduced by following [this...
0
answers
0
votes
38
views
asked 10 months agolg...
I am using AWS Glue for data ETL to load data from MySQL into Redshift.
In MySQL, the types of the three columns, type, sub_type, and status, are all unsigned int.
However, when stored in Redshift,...
0
answers
0
votes
50
views
asked 10 months agolg...
I am using Redshift Data API to fetch the records from redshift. If the timeout is not mentioned manually the query is not returning records.
The error thrown...
0
answers
0
votes
82
views
asked a year agolg...
Hi,
I am using a Redshift cluster that has a few databases and multiple schemas under each of those. In one of the db, I have created a schema named 'analytics' that has several views pointing to...
0
answers
0
votes
47
views
asked a year agolg...
Hello,
Redshift query editor v2 has suddenly started not to run saved queries. When I select from a table and click run, the query runs. But as soon as the query is saved, the run button is...
0
answers
0
votes
113
views
asked a year agolg...
I am receiving the "DATE data type can be used only with text, Parquet, or ORC data files, or as partition column." for queries on a JSON-based external table:
![Enter image description...
0
answers
0
votes
107
views
asked a year agolg...
Hi,
i want to query last modify date of when any of the data was changed in the table in Redshift 1.0.49780.
0
answers
0
votes
98
views
asked a year agolg...
Source: MySQL
Destination: AWS Redshift
We have created few dms tasks for multiple tables that need to be migrated. It seems there is an issue with the migrate type "migrate existing and replicate...
0
answers
0
votes
105
views
asked a year agolg...
Hello,
Would like to know what this error means, please refer below to the message displayed when query is ran via ETL Manager
error: Assert code: 1000 context: *extraction->numexprs < MAX_COLS-...
0
answers
0
votes
72
views
asked a year agolg...
I am trying to create a new scheduled query using ARN and secret manager. I created 4 of them in the past.
Today, it is not working, it does not give any errors. when I click on save changes it just...
0
answers
0
votes
93
views
asked a year agolg...
I was trying out aurora MySQL 8.0 compatible zero ETL integration preview with redshift. I was getting "you don't have access to change data stream feature" redshift cluster was in the same region as...
0
answers
0
votes
245
views
asked a year agolg...