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,
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
116
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
112
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
100
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
109
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
73
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
96
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
248
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
81
views
asked a year agolg...
All,
I recently updated an AVRO Schema. I have checked that the updates made to the schema are backward compatible; and they are. Next, I saved an avro file w/ the new schema to an s3 Bucket and...
0
answers
0
votes
47
views
asked a year agolg...
What is the latency/SLA of STL_INSERT, STL_DELETE and STL_QUERY? For example, how soon after an INSERT query is run is it guaranteed to show up in STL INSERT?
Can a query show up in STL_INSERT but be...
0
answers
0
votes
31
views
asked a year agolg...
I want to query data from dynamoDB using GSI and sort key through Amplify Datastore. Is this possible?
0
answers
0
votes
142
views
asked a year agolg...
I have a Redshift serverless workgroup inside a VPC, and I want to securely create a federated schema of an RDS Aurora cluster through a security group or another mechanism. The Aurora cluster is in...
0
answers
0
votes
147
views
asked a year agolg...