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.
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
52
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
119
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
118
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
105
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
117
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
74
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
107
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
259
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
88
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
48
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
32
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
149
views
asked a year agolg...