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, I have assigned a system defined role "Sys:dba" to a user, but this role has no permissions.
I have used: `GRANT ROLE sys:dba to "user";`
According to the...
Accepted AnswerAmazon Redshift
1
answers
0
votes
387
views
asked 9 months agolg...
I am continuing to get timeouts with this configuration:
```
conn = redshift_connector.connect(
host='examplecluster.abc123xyz789.us-west-1.redshift.amazonaws.com',
port=5439,
...
1
answers
0
votes
486
views
asked 9 months agolg...
Hello team,
If I have purchased a 3-year RI for a 2-node ds2.xlarge cluster with a partial upfront payment. Now, trying to resize the existing 2-node ds2.xlarge cluster to a 1-node ra3.xlplus cluster....
2
answers
0
votes
360
views
asked 9 months agolg...
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
292
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
311
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
217
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
486
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
496
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
579
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
434
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
253
views
asked 9 months agolg...