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
Filter questions
Select tags to filter
Sort by
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
1066 results
I tried to upload jpg format file and pdf files into the system, from both my PC and S3, which are taking like forever to upload / not able to pick from redshift.
Could someone here please help
1
answers
0
votes
4
views
asked 6 days ago
Hello, I would like to test new RA3 nodes as older ones (DC2) are deprecated. I tried to use instructions I got via email, but on StepFunction starting got an error
```
{
"errorMessage": "An error...
1
answers
0
votes
36
views
asked 14 days ago
I'm trying to set up the Glue and Redshift connection. I created several endpoints for S3, Redshift, KMS, and Secret Manager, but I'm getting this error. I don't understand where this VPC value was co...
1
answers
0
votes
64
views
asked 15 days ago
We use Amazon Redshift as our main data warehouse and want to adopt dbt Mesh to enable cross-platform data sharing between Redshift and Snowflake.
Currently, dbt Mesh depends on Apache Iceberg as the...
1
answers
0
votes
35
views
asked 22 days ago
Hello everyone,
I'm currently trying to create a connection to Amazon Redshift ServerLess using AWS Glue Studio, but I'm encountering the following error:
`Failed to create connection: InvalidInputE...
1
answers
0
votes
86
views
asked 24 days ago
Hello AWS Community,
We plan to upgrade our consumer Redshift cluster from ra3.xplus to ra3.4xlarge using an elastic resize.
Will this operation cause any loss or reset of the following configurati...
3
answers
0
votes
50
views
asked a month ago
AZ is us-east-1e
I'm trying to migrate my Redshift DC2 cluster to RA3 before the EOL deadline early next year, but the resize operation keeps failing immediately with no error messages.
I've been tr...
1
answers
0
votes
71
views
asked a month ago
We've migrated to zero ETL and have noticed some performance differences that are down to auto materialized views being used for simple aggregates on our 'old' setup, but no such auto materialzed vie...
1
answers
0
votes
28
views
asked a month ago
I have an S3 bucket that is populated by csv files from the output of an API run. The problem is that before and after a particular date, my column order is different which is causing the load job to ...
1
answers
0
votes
49
views
asked a month ago
I’m working with AWS DMS to replicate data from **Aurora PostgreSQL (RDS)** to **Amazon Redshift** using **full load + CDC**.
* **Task 1 (Single-Tenant Schema):**
Replicates from one schema only. N...
1
answers
0
votes
73
views
asked a month ago
We create the following operator on our redshift cluster:
CREATE OPERATOR public.&& (
LEFTARG = GEOMETRY,
RIGHTARG = GEOMETRY,
PROCEDURE = ST_Intersects
);
The operato...
1
answers
0
votes
29
views
asked a month ago
I have an Aurora RDS Postgres cluster running 17.4. I've enabled ZeroETL to our Redshift cluster.
The Redshift Cluster is in another AWS account but both are in the us-west-2 region.
I've enabled ...
1
answers
0
votes
31
views
asked 2 months ago