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
467
views
asked 3 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
1696
views
asked 3 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
283
views
asked 3 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
340
views
asked 3 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
337
views
asked 3 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
285
views
asked 3 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
206
views
asked 3 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
150
views
asked 3 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
199
views
asked 3 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
294
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
871
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
253
views
asked 4 months agolg...