4 ms·

Our most shocking discovery on Redshift was that primary key constraints are not honored. (Not sure why they even have PK identifiers given this, it just adds m

Our most shocking discovery on Redshift was that primary key constraints are not honored. (Not sure why they even have PK identifiers given this, it just adds more confusion.)

deleted 4y ago
[deleted]
jw887c 4y ago
This is the case for most column oriented data warehouses (including BigQuery, but Snowflake does allow for 1 PK). It's just the nature of the technology.
dits59 4y ago
Suppose you are using AWS Datapipeline, it will make use of PK to get rid of duplicates.