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.
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
354
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
361
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
409
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
333
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
261
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
163
views
asked 5 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
231
views
asked 5 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
353
views
asked 5 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
1231
views
asked 5 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
282
views
asked 5 months agolg...
We have an SQL producing results with lots of NULL fields. The code contains almost 1800 lines with many subqueries but the outermost query is a **left outer join** of 2 subqueries (named **t_1** and...
2
answers
0
votes
255
views
asked 5 months agolg...
is it possible to conveniently mask all columns in a Redshift table? The example in the [docs](https://docs.aws.amazon.com/redshift/latest/dg/t_ddm.html#ddm-example) only masks one column but is there...
1
answers
0
votes
520
views
asked 5 months agolg...