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.
Redshift - Four ra3.4xlarge vs a single ra3.16xlarge - what is the performance advantage (if any)?lg...
if i am experiencing long running queries and 100% CPU utilization once a day, would moving from four ra3.4xlarge to a single ra3.16xlarge help?
1
answers
0
votes
373
views
asked 8 months agolg...
Is it currently possible to use Zero-ETL Integrations between Aurora PostgreSQL and Redshift. These Database Instances are in 2 different AWS Account.
If this is not possible, how do I replicate the...
1
answers
0
votes
469
views
asked 8 months agolg...
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
412
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
967
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
508
views
asked 9 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
320
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
402
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
168
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
189
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
382
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
482
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
358
views
asked 9 months agolg...