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,
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
344
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
346
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
288
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
271
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
485
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
763
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
466
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
291
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
860
views
asked 7 months agolg...
Running a basic UNLOAD ([docs](https://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html)) query from redshift like the one below:
```
unload('select id, name from schema.table_name where col =...
2
answers
0
votes
224
views
asked 7 months agolg...
Documentation says it was to be out of Preview on October 15th. We still cannot access it. Is there a new target date?
https://docs.aws.amazon.com/redshift/latest/dg/r_COPY-JOB.html
Also... would be...
Accepted AnswerAmazon Redshift
2
answers
1
votes
234
views
asked 7 months agolg...
We have a redshift cluster with ds2.xlarge nodes. We can NOT connect to it.
We tried to reboot it. The cluster is back with status as Available, but no Storage capacity used shown in the console....
1
answers
0
votes
339
views
asked 7 months agolg...