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.
In our architecture we have data from AWS MSK being ingested into AWS Redshift using the Amazon Redshift Streaming Ingestion feature. In this approach, we define an external schema where we have the...
0
answers
0
votes
118
views
asked 7 months agolg...
We had four nodes (640GB) and discovered that all of our disk space has been consumed.
There were, however, two reserve nodes (each 160GB). So we resized the cluster using "Classic resize" to take...
1
answers
0
votes
275
views
asked 7 months agolg...
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
300
views
asked 7 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
476
views
asked 7 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
682
views
asked 7 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
120
views
asked 7 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
505
views
asked 7 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
246
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
438
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
258
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
290
views
asked 7 months agolg...
I've implemented the automatic mounting of the Glue catalog following this process:...
1
answers
0
votes
332
views
asked 7 months agolg...