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 use the scheduler from Redshift query editor v2 to run a SP every 5 minutes. The SP typically completes in 1-2 minutes. Occasionally the SP takes > 5 minutes due to various reasons (CPU, I/O spike,...
4
answers
0
votes
496
views
asked 4 months agolg...
I need to optimize costs on my AWS account, and one of the things I want to do is to reserve a node for my redshift cluster. `dc2.large` instance is more than enough for me, however I am unable to...
1
answers
0
votes
1954
views
asked 4 months agolg...
I try to create a materialized view based on an external table in the glue data catalog.
Quering the Schema and tables of the data catalog work like expected. Also the creation of normal views...
1
answers
0
votes
327
views
asked 4 months agolg...
Hi,
I am considering Glue to connect to a third party application's database (Oracle) and bring a data set (in excess of 1M rows) obtained by joining multiple tables at source end. The destination...
1
answers
0
votes
352
views
asked 4 months agolg...
I am trying to read data from redshift schema_a and write its output into another redshfit table in schema_b. Below is the code I am using to read from...
3
answers
0
votes
380
views
asked 4 months agolg...
not able to drop the group in redshift database facing the error
group "XXXX" cannot be dropped because permission dependency is found
3
answers
0
votes
312
views
asked 4 months agolg...
The Zero ETL Integration for replicating data to Redshift from Aurora PostgreSQL is currently in "Preview", as [this post specifies...
1
answers
0
votes
232
views
asked 4 months agolg...
Hello,
Currently SCT doesn't support Redshift as target with Db2 LUW as source database. Could you share what solutions are available for schema conversion for Redshift?
0
answers
0
votes
161
views
asked 4 months agolg...
Hi,
Last weekend 20/01/2024, after automatic maintenance upgrade of our provisioned redshift cluster (in eu-west-1a) to version 1.0.61678, all our LOAD commands started to fail. Also queries to...
1
answers
0
votes
213
views
asked 4 months agolg...
We use Redshift for internal purposes.
As a part of that, we want to determine the data lineage of the tables available in the Redshift cluster.
---
To generate lineage entries, we traditionally...
1
answers
0
votes
319
views
asked 4 months agolg...
Hi. I am trying to run an AWS Glue job where I transfer data from S3 to Amazon Redshift. However, I am receiving the following error:
```
Error Category: UNCLASSIFIED_ERROR; An error occurred while...
2
answers
0
votes
1059
views
asked 4 months agolg...
My redshift cluster has automatic snapshots which are being created. Is there a way for me to access the incremental data to the cluster ? I do not want to restore the cluster, I want incremental data...
1
answers
0
votes
269
views
asked 4 months agolg...