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.
Hi,
We have noticed our AWS Redshift cluster instance restarting outside the maintenance window.
Last Monday , Sept 11 we have a restart outside our weekly maintenance window.
This has occurred in the...
1
answers
0
votes
280
views
asked 8 months agolg...
Hi All,
I hope everyone is doing well! I am attempting to create a federated query between Redshift and Aurora Postgres 14.
I am following the instructions on this page:...
0
answers
0
votes
203
views
asked 8 months agolg...
Per the documentation ([Setting LOB support for source databases in an AWS DMS task](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html)) there are three modes: Full LOB Mode,...
1
answers
0
votes
444
views
asked 8 months agolg...
Hello, Following is a gist of how to perform a cross-region and cross-account redshift copy from a DynamoDB table.
Note: Couple of considerations,
1. Similar to any other AWS service, you need to...
0
answers
0
votes
207
views
asked 8 months agolg...
I created a Materialised view on Redshift on top of Kinesis Streaming Ingestion with Auto Refresh Yes I set the retention period of my Kinesis Data Stream to 1 day. Even after 2 days I can able to see...
1
answers
0
votes
453
views
asked 8 months agolg...
**How to install python packages dependencies which supports user defined package for Glue Spark job? **
For example, I have used redshift_connector package inside my custom package. In my Spark job,...
2
answers
0
votes
524
views
asked 8 months agolg...
While designing tables for Enterprise Data Warehouse (EDW), I found some instructions, for example https://docs.aws.amazon.com/redshift/latest/dg/c_designing-tables-best-practices.html. But, I concern...
1
answers
0
votes
402
views
asked 8 months agolg...
I want to set query_group when run statements using BatchExecuteStatement.
the batch sqls to run is
```
set query_group to 'group_label';
call sp_abc();
reset query_group;
```
sp_abc will call 2...
Accepted AnswerAmazon Redshift
1
answers
0
votes
233
views
asked 8 months agolg...
I have for example two tables with the same data.
```
CREATE TABLE version1 (
col1 INTEGER ENCODE AZ64,
col2 INTEGER ENCODE ZSTD,
);
CREATE TABLE version2 (
col1 INTEGER NOT NULL DEFAULT 0...
Accepted AnswerAmazon Redshift
2
answers
0
votes
648
views
asked 8 months agolg...
I created an external schema (for glue data catalog and subsequent s3 data) in Redshift Serverless using query editor v2.
For the IAM role I used 'SESSION' to make sure that all the users that are...
1
answers
0
votes
417
views
asked 8 months agolg...
Unable to install External python librarires(e.g.redshift_connector==2.0.913) in AWS Glue Spark Job through Job Parameters option "--additional-python-modules" .
1
answers
0
votes
379
views
asked 8 months agolg...
We have a DMS CDC task. Source Mongo, destination Redshift. It's been running fine for months.
When we stop and restart, several tables load, but others don't. There are no errors being logged in...
2
answers
0
votes
684
views
asked 8 months agolg...