Snowflake’s platform enables organizations to seamlessly analyze and securely share data throughout the business. However, even when your data is all in one place, it still requires visibility, control, understanding and security. Snowflake’s platform secures the data so that users can collaborate with confidence around that data. Snowflake works with partners like Collibra to provide data governance capabilities that ensure customers know where their data is, provide secure, compliant access to the data, and unlock their data’s full potential within the cloud.
Data governance with Snowflake and Collibra
Collibra provides out-of-the-box and fully customizable workflows to simplify the process of managing and accessing data throughout the organization. Combining Collibra with Snowflake enables more users to trust and understand their data. With data governance, organizations can leverage the full power of Snowflake while complying with data privacy and policy requirements.
Data masking and policy enforcement
Snowflake’s Dynamic Data Masking, allows data owners to easily protect and manage sensitive data. This feature is necessary for data governance because it ensures only the right people have access to the right data. But in order for customers to take advantage of this feature, they need Collibra’s Policy Enforcement.
Collibra and Snowflake enable data platform teams to provide secure data access at scale, service the enterprise governance requirements, and enable self-service data analytics to increase usage and adoption of the data lake. Collibra and Snowflake enforce data access policies at run-time, so each user will only see the data they are authorized to view. Access restrictions can be applied at the table and column level, and Snowflake allows for a variety of de-identification types, including masking, redaction and tokenization. Technical stewards (and owners if no steward assigned) are prompted to grant the requesting user access to resources.
For example, when a business analyst goes into Snowflake to access the data they need to run a report, the data may be tokenized due to Dynamic Data Masking. This is great because it protects the data and ensures compliance, but it also means that the business analyst may not have access to all the data they need for certain business needs. With Collibra Policy Enforcement, this business analyst can request access to the data within Collibra and then an automatic workflow is triggered to alert the data owner of the request. Collibra then provides just enough information so that the data owner can see what access will be granted and what the implications are for granting this access. Once the data owner assesses the risk, they can grant the business analyst access. This process ensures compliant access to data, while also allowing business analysts to get the full access that they need to do their job.
Object tagging and ML-powered automation tagging
Another Snowflake governance feature is object tagging. Object Tagging makes it easier to know and control your data by applying business context, such as tags that identify data objects as sensitive, PII or belonging to a cost center. With Object Tagging users can create their own library of custom tags and associate them to desired objects such as columns, tables/views, databases, warehouses and more.
But tags by themselves don’t enforce any security controls. Collibra provides ML-powered automation capabilities that add business context to data at scale, including identifying and tagging sensitive data. Collibra enables organizations to have the necessary context to make sure data is classified, categorized and tagged appropriately. The information in Collibra is utilized by Snowflake so that objects have the right tags based on business context and use. Together, Snowflake’s object tagging and Collibra’s ML-powered automation helps users easily recognize which data is sensitive and should be protected.
Access history and Collibra Data Lineage
Access history is one of Snowflake’s newest features. Snowflake’s new support for data modification in Access History helps customers know their data end-to-end, from both external sources and as it flows within Snowflake, making compliance auditing easier and faster.This helps organizations comply with regulatory compliance such as GDPR and CCPA.
To extend the view of lineage beyond Snowflake, Collibra Data Lineage provides that additional context by automatically mapping relationships between data points to show how data moves from system to system and how data sets are built, aggregated, sourced and used — providing complete, end-to-end lineage visualization. Collibra Data Lineage automates the creation of data lineage and provides both a business-friendly and technical view of data from source to report so that users have the full picture of their data.
Proud to be part of Snowflake’s Governance Accelerate Program
We are excited to be a featured partner of Snowflake’s Governance Accelerated Program. At Collibra, we recognize the benefits of using a cloud platform like Snowflake. But we also see the gaps. Our integration offers customers the highest level of data governance in the market. Together, we help customers unlock the value of their data, while also understanding and protecting their data. We look forward to our continued partnership with Snowflake to provide top level data governance.
