CODEWITHSUNDEEP
snowflake-cloud-data-platform
Woodsman
Woodsman

Reputation: 1179

Constraints in snowflake database and performance

I've read the docs on Snowflake and realize Snowflake does not enforce constraints, except for not nulls. However, does Snowflake use these constraints in any way to help optimize queries?

Upvotes: 1

Views: 175

Answers (1)

Felipe Hoffa
Felipe Hoffa

Reputation: 59325

Check this Snowflake post by Kent Graziano:

Basically these constraints are useful even when the database doesn't use the constraints, for reasons like:

  1. Design Metadata (people and code trying to understand your schema)
  2. BI Metadata (tools like Looker and Tableau can leverage this information)
  3. Quality assurance (run checks to verify that the design is being respected)

Upvotes: 1

Related Questions