Overview

This one‐day Snowflake Data Governance add‐on course provides participants with skills and practice to successfully use Snowflake data governance features to support an organization’s data governance program.

You will apply data governance techniques to ensure trustworthy data while making it available to different types of users. You will use features that identify and protect sensitive information and track the data to enable regulatory compliance.

This course consists of lectures, demos, and labs.

Skills Covered

  • Detect and classify sensitive data.
  • Restr access to sensitive data with policy-based row access control.
  • Control the visibility of sensitive data with policy-based data masking.
  • Determine who queried and updated data with access history.
  • Implement privacy-preserving collaboration with advanced privacy policies.
  • Extend data governance to data stored in your data lake and Apache Iceberg™ Tables.
  • Analyze the downstream impact of planned changes.
  • Generate synthetic data for non-production environments.
  • Leverage the latest Horizon governance features for the era of Enterprise AI.
  • Identify the lineage of data objects.
  • Manage and track the use of sensitive data.
  • Extend data governance to data stored in your data lake.
  • Govern data shared with multiple internal and external users

Prerequisites

  • Recommended completion of the “Snowflake Multi-Factor Authentication (MFA) Essentials” free on-demand course.
  • Recommended completion of one of the following courses, or equivalent experience:
    • “Administering Snowflake”
    • “Snowflake Data Engineer”
    • “Snowflake Fundamentals”
  • SQL skills and a database administration or database management background are required.

Target Audience

  • Data Stewards
  • Snowflake Administrators
  • Governance, Risk, and Compliance staff
  • Data Security Administrators
  • Privacy and Compliance Officers
  • Data Engineers
  • Data Architects
  • Anyone involved with or interested in data governance in Snowflake

Course Curriculum

Identify Data Sensitivity

  • Sensitive Data Classification
  • Automatic Data Classification
  • Object Tagging

Protect Your Data

  • Data Governance Policies
  • Context Functions in Data Governance Policy Conditions
  • Row Access Policies
  • Data Masking
  • External Tokenization

Using Data Governance with Data Lakes

  • Apache Iceberg™ Tables Governance
  • Data Lakes and Data Governance

Sharing Sensitive Data

  • Data Sharing Overview
  • Recommendations and Considerations

Advanced Privacy Policies

  • Projection Policies
  • Aggregation Policies
  • Join Policies

Track and Analyze Your Data

  • Access History (Reads)
  • Access History (Writes)
  • Access History and Column Lineage
  • Audit Access History
  • Impact Analysis

Tools for Data Stewards

  • Tools for Data Stewards

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

Trainocate exam and cert

Exam & Certification

Training & Certification Guide

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes