06 - Data Governance

Data Governance Model

  • Programmatically grant, deny, and revoke access to data objects

GRANT on TO <User/Group>

-- Grant Privilege on Database
GRANT SELECT, MODIFY, READ_METADATA, CREATE on SCHEMA hr_db TO hr_team;

-- Grant Privilege on Table
GRANT SELECT ON TABLE my_table to user_1@company.com

-- Grant Privilege on View
GRANT SELECT ON VIEW hr_db.paris_employees_vw to 'admin@mycompany.com';

alt text

alt text

Data Explorer

Data Explorer is really useful and powerful tool to manage your data objects.

Unity Catalog

  • Centrlaized governance solutions across al your workspaces on any cloud
  • Unify governance for all data and AI assets
    • Files, Tables, ML Models and Dashboards
    • Based on SQL

alt text

Unity Catalog Hierarchy

  • Unity Catalog 3-Level Namespace
SELECT * FROM schema.table
To
Select * FROM catalog.schema.table

alt text

Unity Catalog Architecture

alt text

UC Features

  • Centralized Governance for Data and AI
  • Built-in Data Search and Discovery
  • Automated Lineage
  • No hard migration required