Re:Amazon Redshift re-invented
by TuringNYC on Monday May 23, 2022 @06:07PM
(#31485408)
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.)
[ Parent
| on HN ]
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.