Questions tagged with Amazon Redshift
Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS-designed hardware and machine learning to deliver the best price performance at any scale.
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.
929 results
Presently cannot upgrade my version of python SQLAlchemy to version 2.0 because redshift dialect doesnt support it.
There is an open github issue on...
Hi everyone,
I am facing an issue while creating Amazon Redshift wrangler in Amazon SageMaker Studio. I receive the following error message:
*A customer error has occurred. See the error reason...
I have few queries in aws redshift which I want to schedule using redshift schedule feature so that I can run those queries according to specific requirements. I want to do this work using...
Hi,
I wanted to access server based RedShift cluster from Amazon SageMaker. While trying to connect I got the error message saying
connection to server at...
I have been trying to send data from Salesforce to Redshift using App Flow. Every time when I setup the flow I am getting an error 'Connector timed out'. I have tried both serverless and cluster. I am...
I have a glue job that is supposed to read from DynamoDB table of size 1.4GB, process it and write to Redshift. The job always fails with:
**'An error occurred while calling o181.pyWriteDynamicFrame....
Hi! I'm currently facing an issue trying to equally distribute data among nodes, this is my current situation:
I used this query...
I have a AWS glue table with one partition named dt, i can add data in my s3, using Athena via this glue table and can also query it.
But I am not able to query data using redshift query editor.
I...
vacuum is taking too much time on any table. Even on a table with just 36 records, it didn't succeed even after executing for more than 2.5 hours and I had to cancel the query.
How can I resolve...
We built a redshift serverless cluster that is managing it's secrets in secrets manager as described here:...
Zero-ETL appends 2 additional columns to the redshift table (padb_internal_txn_seq_col, padb_internal_txn_id_col). Does anyone know how I can use those values to identify only the most recent inserts...
I have 100+ Aurora mySQL schemas that all have a Users table. These use zero-ETL to copy the data into a Redshift zero-ETL database.
1. What is the most efficient and trouble-proof way to append all...