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.
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
37
views
asked 9 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
79
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
112
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
105
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
81
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
100
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
89
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
239
views
asked a year agolg...
Hi,
I am trying to use EXTENSION parameter in Redshift UNLOAD function to save file in .csv extension in S3 bucket. However, I am getting the error: "ERROR: syntax error at or near "EXTENSION" .
As...
0
answers
0
votes
80
views
asked a year agolg...