2022-12-06

Governance Management in Snowflake

Governance Management in Snowflake

Snowflake provides functionalities to ensure governance for all data stored and accessed in Snowflake, in addition to accounts and users.

  • Column-Level Security
    Apply masking policies to columns within tables or views.
  • Row Access Policies
    Apply row access policies to tables or views.
  • Object Tagging
    Track sensitive data for compliance, detection, protection, and resource usage.
  • Tag-Based Masking Policies
    Combine object tagging with masking policy functionality to set masking policies based on tags.
  • Data Classification
    Classify data that may contain personal and/or confidential information.
  • Access History
    Audit user access history.
  • Object Dependencies
    Audit how one object refers to another object through metadata, such as creating views that depend on table and column names.

However, it seems that most of the governance features are only available in Snowflake editions that are Enterprise or higher.

Feature Edition
Column-Level Security Enterprise or higher
Row Access Policies Enterprise or higher
Object Tagging Enterprise or higher
Tag-Based Masking Policies Enterprise or higher
Data Classification Enterprise or higher
Access History Enterprise or higher
Object Dependencies All Editions

References

https://docs.snowflake.com/guides-overview-govern

Ryusei Kakujo

researchgatelinkedingithub

Focusing on data science for mobility

Bench Press 100kg!