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.
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
328
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
255
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 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
229
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
347
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
1204
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
280
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
253
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
517
views
asked 5 months agolg...
Hello everyone! The problem that I'm having is that I need for a stored procedure in redshift to return a temporary table. Not in the way described here...
Accepted AnswerAmazon Redshift
1
answers
0
votes
465
views
asked 5 months agolg...
Hello,
I found the queries which allows me to add users, roles and grant access to tables etc. However I want have a more automated process so we don't forget steps while e.g. dropping a user/role...
1
answers
0
votes
162
views
asked 5 months agolg...
I am encountering the following error while running my Node.js application to retrieve data using AWS Redshift Serverless.
"'ERROR: permission denied for relation...
1
answers
0
votes
420
views
asked 5 months agolg...