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.

1082 results
I've attempted to create a Redshift DynamoDB Zero-ETL integration multiple times and it has the same failure method every time. I've gone through the setup "Fix it for me" to attach the correct polic...
2
answers
0
votes
48
views
asked 23 days ago
## Short Description When creating an Aurora PostgreSQL zero-ETL integration with Amazon Redshift using Terraform or AWS CLI, you receive the following error: ``` InvalidParameterValue: You don't hav...
1
answers
1
votes
94
views
AWS
asked a month ago
Hi, I'd like to understand the warning in https://eu-west-1.console.aws.amazon.com/redshiftv2/: ``` Switch to the new Queries and Loads page for enhanced security, 7-days query history, and [query pr...
2
answers
0
votes
31
views
asked a month ago
Since upgrading to Redshift version 1.0.179517 (patch 197) we have randomly started getting frequent "could not complete because of conflict with concurrent transaction" errors. I have looked in table...
1
answers
0
votes
89
views
asked a month ago
How does Redshift evaluate an INNER JOIN that’s outside a derived table in the FROM clause? Does it filter before the derived table “selects” its columns? I’m trying to understand the expected (and/o...
1
answers
0
votes
76
views
asked a month ago
Hello there ! I have a situation that I couldn't find anything else online. Basically, I have two AWS accounts, where I have two Redshift clusters. On prod, I have an old dc2.large node and on dev, I...
1
answers
0
votes
32
views
asked 2 months ago
Hi, I have a full data sharing scenario setup between two same-region but different AWS accounts. On the producer side, I am using external schema pointing to a Glue catalog with Iceberg tables. On th...
1
answers
0
votes
43
views
asked 2 months ago
We have 125 tables in the source cluster DB. The filter is set to include: `core_analytics.*.*` (but we've tried other filters as well). For a few days the integration syncs all 125 tables but then i...
2
answers
0
votes
65
views
asked 2 months ago
I'm joining a fact to a dim table on patient ID, which is a BIGINT in both tables and the distkey for both tables. When I run the broken query, it returns with each patient ID having a count of 1. How...
1
answers
0
votes
31
views
asked 2 months ago
Our organization recently migrated our Redshift cluster type from DC2 to RA3 through Elastic Resize on Amazon. However, the billing charges ended up being higher. We were informed that if the migratio...
3
answers
0
votes
146
views
asked 2 months ago
We are experiencing intermittent inconsistent behavior on Amazon Redshift Serverless during routine DROP TABLE, CREATE TABLE, and ALTER TABLE RENAME operations executed via dbt. The problem presents a...
2
answers
0
votes
69
views
asked 2 months ago
How to apply password policies to standard database users in Redshift? e.g. Password length, one uppercase letter, one lowercase letter, one number, one special character etc. Password should not be s...
1
answers
0
votes
63
views
asked 2 months ago
  • 1
  • 2
  • 3
  • 4
  • 5
  • •••
  • 91
  • Page size
    12 / page