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 read data from s3 using as follow.
```
sec_id_dyf = glueContext.create_dynamic_frame.from_options(
connection_type = 's3',
...
0
answers
0
votes
91
views
asked 9 months agolg...
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
127
views
asked 9 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
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
75
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
103
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
98
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...