Data classification for Snowflake
Published Feb 08 2023 12:28 PM 3,404 Views
Microsoft

I am pleased to announce support for automatic data classification for Snowflake data source in Microsoft Purview Governance. This functionality is now generally available.

 

When you classify data assets, you make them easier to understand, search, and govern. Classifying data assets also helps you understand the risks associated with them. This in turn can help you implement measures to protect sensitive or important data from ungoverned proliferation and unauthorized access across the data estate. With automatic classification, customers can use 200+ built-in system classifications to easily identify sensitive information in the data source. Additionally, you can create custom classifications to automatically tag data that is specific to your organization like Employee Id or Product ID etc.

 

To automatically apply classification, simply set up a new scan.

 

Ankit_Gupta_0-1675805641805.png

 

Select either the default Snowflake scan rule set or create a custom scan ruleset.

 

Ankit_Gupta_1-1675805684796.png

 

Run the scan one time or schedule it to run at a regular interval.

 

Ankit_Gupta_2-1675805707326.png

 

Once the scan is complete, navigate to Data Catalog to view the assets discovered and classified by scan. If sensitive data was found, then you will see the relevant classifications on the schema.

 

Ankit_Gupta_3-1675805728772.png

 

Note: Self-hosted runtime (SHIR) version 5.26.404.1 or higher is required to classify data in Snowflake. You can find the latest version of Microsoft Integration runtime here.

 

Learn more about how to setup automated scan on Snowflake: Connect to and manage Snowflake - Microsoft Purview | Microsoft Learn

 

Learn more about how to automatically apply classification during scan: Automatically apply classifications on assets - Microsoft Purview | Microsoft Learn

Co-Authors
Version history
Last update:
‎Feb 08 2023 12:28 PM
Updated by: