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.
1114 results
Environment: Amazon Redshift provisioned, us-east-2, version Redshift 1.0.539507. Reproduced on two clusters.
A query fails at planning with:
ERROR: Query unsupported due to an internal error. DETAI...
2
answers
0
votes
69
views
asked 5 days ago
Observed on Redshift 1.0.520420.
## Summary
When `x` is NULL, Redshift evaluates `x IS NOT NULL AND x <> ''` to NULL in a SELECT list, CASE expression, or aggregate. It should be FALSE because `FALS...
2
answers
-1
votes
94
views
asked 11 days ago
I’m creating an S3 event integration for Redshift auto-copy using CloudFormation and it fails every time with the same error. The bucket policy appears to contain the permissions from the documentatio...
1
answers
0
votes
89
views
asked 19 days ago
My data is in Amazon Redshift Serverless. In a SageMaker Unified Studio (DataZone V2) domain, the tables appear as Redshift Table assets, discovered by a Redshift data source. I evaluate data quality ...
1
answers
0
votes
102
views
asked 19 days ago
Every IAM Identity Center (IdC) login to Redshift Serverless fails with:
```
FATAL 28000: Insufficient privileges to access AWS IdC API.
(server file identity_provider_auth.cpp, line 107, R=AuthFail)...
2
answers
1
votes
134
views
asked 20 days ago
## Amazon Redshift password user keeps getting locked, even after I reset it
**Error**
```
FATAL: Account locked due to multiple failed login attempts. [SQL State 28000]
```
I unlock the user, but ...
1
answers
0
votes
120
views
asked a month ago
I am trying to delete a provisioned Amazon Redshift cluster that is integrated with the AWS Glue Data Catalog (lakehouse / unified governance). The deletion is blocked with:
> The cluster has an asso...
1
answers
0
votes
102
views
asked a month ago
Hi team, I see that Amazon Aurora PostgreSQL 18.3+ already natively supports zero-ETL pipelines to Amazon Redshift. However, our current architecture relies on standard Amazon RDS, and we are planning...
2
answers
0
votes
138
views
asked a month ago
We have a zero-ETL integration from Aurora MySQL to a provisioned RA3 cluster (eu-central-1, 282 tables, about 260 GB). Since 2026-09-25, Redshift runs refresh cycles back-to-back and ignores REFRESH_...
1
answers
0
votes
116
views
asked 2 months ago
I have a Redshift Serverless workgroup in us-east-1 whose Amazon-managed SSL certificate has expired and does not appear to have been automatically rotated.
**Certificate Details:**
Subject: CN=***.u...
2
answers
0
votes
191
views
asked 3 months ago
After a cluster was patched to **1.0.377293 (Patch 203)** last week, any session that leaves a partially-consumed result set open is terminated after almost exactly **300 seconds**:
```
org.postgresq...
1
answers
0
votes
156
views
asked 3 months ago
For a few days, materialized views were visible as tables in the objects tree in Redshift Query Editor v2, as in other external editors such as DBeaver. This is helpful because it allows to see the co...
2
answers
0
votes
148
views
asked 3 months ago