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 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
667
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
380
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
416
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
345
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
349
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
290
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
272
views
asked 7 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
491
views
asked 7 months agolg...
There are many tutorials available for clustered Redshift, but there are no tutorials for the serverless type to connect it to Power BI. My issue is that I don't know how to configure Redshift for...
1
answers
0
votes
777
views
asked 7 months agolg...
Hi,
We are currently debating whether to invest in a single node or 2-node ra3.xlplus Redshift cluster. We are a small company with limited usage right now, but need room to grow our analytics...
1
answers
0
votes
471
views
asked 7 months agolg...
Assert code: 1000lg...
Hello,
We have two clusters sharing data via datashare. Since this morning, we have encountered the following error:
```
[2023-10-24 07:47:26] [XX000] ERROR:
[2023-10-24 07:47:26]...
1
answers
3
votes
292
views
asked 7 months agolg...
I have been attempting to follow [the documentation](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-programming-etl-libraries.html) for developing Glue jobs locally.
Upon running the recommended...
2
answers
0
votes
877
views
asked 7 months agolg...