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 I´m about to start an ETL Job, usually I ask some main questions:
1. Where the original file/table is stored?
2. What should I do to delivery data to my end goal?
If I have already all the data...
1
answers
0
votes
455
views
asked 7 months agolg...
Once in a while we seem to get below error in our redshift cluster. It is usually solved by deleting and recreating the affected table. I would however like to understand more in detail why this is...
1
answers
0
votes
261
views
asked 7 months agolg...
Hi, I am trying to get the number of queries executed against Redshift but I found it very difficult to find it for each IAM user in our organization.
The problem is that most of the queries on...
1
answers
0
votes
296
views
asked 7 months agolg...
I've implemented the automatic mounting of the Glue catalog following this process:...
1
answers
0
votes
339
views
asked 7 months agolg...
Hi Team,
I am dumping data from redshift to s3 using unload command, however its splitting the file into 1000+ files. I cannot turn parallel off as it takes 3x the amount of times for the redshift...
1
answers
0
votes
680
views
asked 7 months agolg...
I'm inquiring whether it's possible to access the previous version of the catalog table in the ETL job to examine a specific column's content. Presently, as I'm updating the table from the raw bucket...
1
answers
0
votes
387
views
asked 7 months agolg...
The following query returns 'abcd' instead of an empty result set:
```
WITH
not_in_cte AS (
SELECT *
FROM big_table
WHERE id NOT IN (SELECT * FROM small_table)
),
left_join_cte AS (
SELECT...
Accepted AnswerAmazon Redshift
1
answers
0
votes
421
views
asked 7 months agolg...
Hello,
We have several RDS databases connected to our Redshift cluster using external schemas that have been working well for several months. A few days ago, I updated the certificate authority on our...
1
answers
0
votes
354
views
asked 8 months agolg...
I have created a glue catalog table on top of a dynamo DB table using glue crawler.
I'm trying to read this glue table by creating a external schema in redshift on top of glue database.
Glue...
2
answers
0
votes
361
views
asked 8 months agolg...
We have a view in redshift which does UNION and it does not complain about data type mismatch
but when we do a datashare of the view to another cluster and try to do a select , it gives UNION mismatch...
1
answers
0
votes
300
views
asked 8 months agolg...
I'm encountering this error, "[0A000] ERROR: QUALIFY is not supported." when running SQL using the QUALIFY clause. SQL that I ran earlier this week ran fine until I re-ran it today.
Is this a known...
1
answers
0
votes
277
views
asked 8 months agolg...
I am having difficulty working reading and writing complex types from spark to redshift. I am using the EMR-6.12 image. One point of confusion is that the docs...
1
answers
0
votes
506
views
asked 8 months agolg...