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.
We have a redshift serverless namespace -- workgroup.
Automated recovery points are taken every 30mins. Can we reduce the frequency?
Also the same question for Auto-snapshots? Can we reduce the...
1
answers
0
votes
278
views
asked 6 months agolg...
Hi,
I am trying to establish ODBC connectivity between PowerBI and Redshift Serverless and have a bit of a trouble.
When using the latest ODBC Redshift driver and trying to authenticate using AWS...
4
answers
0
votes
446
views
asked 6 months agolg...
I have followed this guide: https://docs.aws.amazon.com/redshift/latest/mgmt/zero-etl-using.setting-up.html to establish the zero-etl integration between my RDS Aurora instance and RMS Redshift...
1
answers
0
votes
648
views
asked 6 months agolg...
https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_FUNCTION.html
says "The IMMUTABLE clause isn't currently supported for Lambda UDFs."
But if you use IMMUTABLE it creates the function...
0
answers
0
votes
118
views
asked 6 months agolg...
I am trying to troubleshoot query performance issues and am seeing the following results out of SYS_QUERY_HISTORY.
| query_id | elapsed_time | execution_time | compile_time | planning_time |...
1
answers
0
votes
452
views
asked 6 months agolg...
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
237
views
asked 6 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
403
views
asked 6 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
247
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
270
views
asked 7 months agolg...
I've implemented the automatic mounting of the Glue catalog following this process:...
1
answers
0
votes
316
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
625
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
365
views
asked 7 months agolg...