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 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
273
views
asked 7 months agolg...
I've implemented the automatic mounting of the Glue catalog following this process:...
1
answers
0
votes
321
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
634
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
368
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
397
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
335
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
329
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
276
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
263
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
467
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
727
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
442
views
asked 7 months agolg...