Skip to content

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
Filter Questions by:

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
AWS

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
AWS

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

  • 1
  • 2
  • 3
  • 4
  • 5
  • •••
  • 93
  • Page size
    12 / page