Loading...

Govern your Snowflake data with Azure Purview

Govern your Snowflake data with Azure Purview

Azure Purview as a unified data governance service keeps expanding support for various data sources across on-premises, multi-cloud, and SaaS applications. It helps you generate a holistic, up-to-date map of your data landscape with automated data discovery. Now you can easily bring over metadata from Snowflake by scanning your Snowflake databases, then manage and govern your Snowflake data in Azure Purview.

 

Register and scan

Azure Purview data source administrators can start by registering Snowflake under the data map, and set up reoccurring or one-time scan. You can choose to scan the entire Snowflake database(s) or scope the scan to selective schemas. When scanning Snowflake, Purview extracts rich set of metadata including Snowflake server, databases, schemas, tables, views, stored procedures, functions, pipes, stages, streams, tasks, sequences, and table/view/stream columns, as well as fetches static lineage on assets relationships among tables, views, and streams. Learn more about the prerequisites and step-by-step instruction to register and scan Snowflake in Azure Purview.

Linda_Wang_0-1639669273374.png

 

Search and browse assets

Once the scan completes, you can discover assets via search or browse.

You can search for the Snowflake assets by keyword, and narrow down results by using the facet filters.

Linda_Wang_1-1639669273396.png

 

To browse, click on the “Browse assets” tile on the Purview home page, navigate to the “By source type” tab and select Snowflake. You can then see the list of Snowflake assets brought in by the scan.

Linda_Wang_2-1639669273401.png

 

View and manage metadata

Click into the asset to view more details including the properties, schema, lineage, and more. You can also add business metadata like descriptions, glossary terms, and manually classify the data assets to further manage and govern your Snowflake data in Purview.

Linda_Wang_3-1639669273411.png

 

Linda_Wang_4-1639669273421.png

 

Get started today!

Published on:

Learn more
Azure Purview Blog articles
Azure Purview Blog articles

Azure Purview Blog articles

Share post:

Related posts

Microsoft Purview compliance portal: Information Protection – MIP auto-labeling for Azure SQL & Storage

Microsoft's Purview compliance portal has added a new feature that enables users to extend sensitivity labels to specific or all subscriptions...

1 day ago

Optimizing Azure Container App Deployments: Best Practices for Pipelines & Security

In this post, we take Azure Container App deployments to the next level with best practices for optimizing pipelines and securing sensitive d...

2 days ago

Seamless Updates, Zero Downtime: Master Continuous Deployment in Azure Container Apps

In this fifth part of our Azure Container Apps series, we dive into the world of Continuous Deployment. Learn how to automate your deployment ...

3 days ago

This Month in Azure Static Web Apps | 09/2024

    We are back with another edition of the Azure Static Web Apps Community! :party_popper:   September was yet another month ...

4 days ago

IPv6 Adoption: Enhancing Azure WAF on Front Door

The transition to IPv6 is a significant step for enterprise corporations, reflecting the evolution of internet technology and the need for a l...

4 days ago

Introducing the Data-Bound Reference Layer in Azure Maps Visual for Power BI

Imagine managing a nationwide sales team and needing to understand how your sales align with factors like population density, competitor locat...

5 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy