Snowflake, Sql, Data Science, Data Engineering, Optimization.
restrictions are reliable for the query optimizer. If you are using dbt, the package constraints can help with setting these constraints. although Snowflake doesn’t enforce most constraints, the query optimizer can consider primary key, unique key, and foreign key constraints during query rewrite