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,
What is the easiest way of accessing data held in a Timestream table from a provisioned Redshift cluster (e.g. to run SQL queries against this table and combine this with other data stored with...
1
answers
0
votes
408
views
asked 8 months agolg...
I have a scenario in which I want to test my redshift workload there could be a possibility of a query load with 40k/hour. I created a python script that will execute the sample queries by...
1
answers
0
votes
957
views
asked 8 months agolg...
Hello.
We have tried the new Zero-ETL integration for the Redshift cluster which is preview now and it's great, except it does not support some RDS MySQL data types (unsigned numeric, JSON, etc.).
So,...
2
answers
1
votes
501
views
asked 8 months agolg...
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
313
views
asked 8 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
399
views
asked 8 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
167
views
asked 8 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
188
views
asked 8 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
379
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
471
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
356
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
288
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
307
views
asked 9 months agolg...