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.
Loading json files from s3, this runs fine but STORED AS is not marked as optional in the documentation
```
create external table spectrum.mytable(id int, updated_at timestamp)
ROW FORMAT SERDE...
1
answers
0
votes
241
views
asked 7 months agolg...
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
418
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
251
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
276
views
asked 7 months agolg...
I've implemented the automatic mounting of the Glue catalog following this process:...
1
answers
0
votes
327
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
644
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
374
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
403
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
338
views
asked 7 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
335
views
asked 7 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
277
views
asked 7 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
265
views
asked 7 months agolg...