Data Warehouses don’t support Primary Key constraint

Ryan Arjun
4 min readNov 16, 2023

Data is the business asset for every organisation which is audited and protected. To gain in their business, it becomes very urgent for every organization to make sure that good quality data is available to everyone who needs it. As data grows in size, it becomes increasingly important to understand the many types and storage methods available.

🔑 A Primary Key constraints is typically applied in OLTP systems. On the OLAP side, I notice that Snowflake, Databricks, and GCP BigQuery do not have a mandated PK.

--

--

Ryan Arjun

BI Specialist || Azure || AWS || GCP — SQL|Python|PySpark — Talend, Alteryx, SSIS — PowerBI, Tableau, SSRS