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 AWS, I need to know is it possible to trigger the **Redshift Data API using Step Functions cross account** and if so how is that possible? Can you please share any blog post link which has...
1
answers
0
votes
291
views
asked 9 months agolg...
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
310
views
asked 9 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
216
views
asked 9 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
480
views
asked 9 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
215
views
asked 9 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
494
views
asked 9 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
574
views
asked 9 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
433
views
asked 9 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
252
views
asked 9 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
721
views
asked 9 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
464
views
asked 9 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
402
views
asked 9 months agolg...