All Content 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
1041 results
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...
3
answers
0
votes
545
views
saim
asked 3 months ago
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...
2
answers
0
votes
402
views
asked 3 months ago
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...
2
answers
0
votes
712
views
asked 3 months ago
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....
0
answers
0
votes
472
views
asked 3 months ago
Hi! I'm currently facing an issue trying to equally distribute data among nodes, this is my current situation: ![current status](/media/postImages/original/IM2R45l2I0StqojJD2AOFOkw) I used this query...
2
answers
0
votes
359
views
asked 3 months ago
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...
1
answers
0
votes
551
views
shivank
asked 3 months ago
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...
1
answers
0
votes
421
views
Pandy
asked 3 months ago
We built a redshift serverless cluster that is managing it's secrets in secrets manager as described here:...
1
answers
0
votes
496
views
asked 3 months ago
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...
1
answers
0
votes
286
views
asked 3 months ago
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...
4
answers
0
votes
433
views
asked 3 months ago
My redshift is secured under VPC. Iam trying to connect to redshift using dedicated username and password created for redshift tables used in power BI. I can unblock my IP address in security...
2
answers
0
votes
365
views
asked 3 months ago