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'm trying to load a parquet in redshift, tried both locally or from S3. I've been trying to use the Load Data tool in Redshift query editor V2. I'm using the "Load new table" (`Create table with...
1
answers
0
votes
325
views
asked 9 months agolg...
I am using AWS Glue to migrate data from Glue Catalog to Redshift Serverless and S3 after some transformations.
Since, I am learning Glue, I am using the Redshift Serverless to save my money.
So, I...
1
answers
0
votes
419
views
asked 9 months agolg...
I was trying to perform Glue ETL transformation and store it in AWS Serverless Redshift database and S3 (both) . However, even the Console generated PySpark sheet fails. Almost none of the methods...
0
answers
0
votes
169
views
asked 9 months agolg...
I am trying to connect AWS Glue Catalog to Redshift, but, I keep getting this error
`An error occurred while calling o86.getSink. The connection attempt failed`
In the logs (a part of it)
File...
0
answers
0
votes
196
views
asked 9 months agolg...
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
393
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
506
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
367
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
294
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
317
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
219
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
501
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
219
views
asked 9 months agolg...