Apr 29, 2026 — 10 min — Platform & AI
BigQuery Keys in dbt Are Optimizer Hints, Not Enforcement
How to use BigQuery primary and foreign key constraints from dbt without confusing optimizer metadata for enforced data integrity.
Outcome: Defined a BigQuery and dbt constraint playbook that keeps optimizer hints, dbt contracts, data tests, compiled SQL review, and INFORMATION_SCHEMA verification in the right order.