~/talk

Unity Catalogue and Purview: Data Governance Bedfellows

Talkat SQLBits 2023 · 2023-03-14..03-18· [data-engineering]
links:none on file
slides:none on file

Live demo integrates Unity Catalog and Microsoft Purview by calling the Unity Catalog REST API and Databricks CLI from Python notebooks, using pyapacheatlas to push custom Apache Atlas type definitions and column-level lineage into Purview. The presenter runs TPCH queries to generate tables (queries take ~40–60s), extracts upstream/downstream relationships and uploads processes so Purview shows mapped source columns. It works end-to-end in the demo, with limits: Purview scan connector needs a self‑hosted runtime, Databricks keeps ~30 days lineage, and scheduled extracts are required.

AI-written summary · about

  1. 0:00Introduction
  2. 1:49Why data governance matters
  3. 2:31Unity Catalog and Purview
  4. 5:43Data lineage explained
  5. 9:40Extending Purview with custom definitions
  6. 14:13Demo setup and Python integration
  7. 18:51Scanning Databricks metadata
  8. 22:46TPC-H dataset for lineage
  9. 26:17Mapping source to target tables
  10. 30:16Column-level lineage in Purview
  11. 34:10Why lineage automation matters
  12. 37:01Cost of poor governance
  13. 39:15Extending beyond Unity Catalog
  14. 43:35Key takeaways
  15. 45:04Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.