Skip to main content

Catalog Management and Data Organization

In this course, you will learn how to design, implement, and govern catalog structures and large-scale data organization with Unity Catalog on the Databricks Data and AI Platform. Divided into five modules, it begins by placing Unity Catalog within the cloud deployment model, covering the account console, regional metastores, and the administrator roles that enable it. You will then translate organizational topology (business units, regions, and dev/QA/prod environments) into a scalable catalog and schema design with naming conventions, ownership, and MANAGE delegation. Next, the course covers secure storage integration with storage credentials, external locations, the managed-storage hierarchy, managed versus external tables, volumes, and Lakehouse Federation. You will then apply access patterns and isolation strategies, including workspace-catalog binding, privilege inheritance, row filters, column masks, and attribute-based access control (ABAC) policies, and validate the outcomes with audit signals. Finally, the course closes with best practices for designing, governing, and operating a Unity Catalog estate. The hands-on demos and labs run on serverless compute and include short Genie Code steps.


Note: For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Skill Level
Associate
Duration
3h
Prerequisites

In this course, the content was developed for participants with these skills/knowledge/abilities:  

• Familiarity with Databricks workspaces and SQL warehouses, including working with notebooks in SQL, Python, or Markdown

• A solid understanding of Unity Catalog and Delta Lake for organizing and managing data assets within the lakehouse

• Introductory awareness of Lakeflow for orchestrating and managing data workflows

• Experience in architecture within larger organizations, to understand the complexities of enterprise-level IT landscapes

• Practical experience querying and analyzing datasets using SQL, including exposure to parameterized queries and data migration tasks

• Hands-on experience with Unity Catalog-enabled workspaces, such as creating and managing catalogs, schemas, and tables

• A solid understanding of enterprise architecture frameworks, including capability mapping and logical architecture

• Working knowledge of data governance principles, including security, compliance, access control, and BI reporting concepts

• Competency in ANSI SQL and a conceptual understanding of how data pipelines and workflow orchestration work

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

See all our registration options

Registration options

Databricks has a delivery method for wherever you are on your learning journey

Runtime

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Register now

Instructors

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

Register now

Learning

Blended Learning

Self-paced and weekly instructor-led sessions for every style of learner to optimize course completion and knowledge retention. Go to Subscriptions Catalog tab to purchase

Purchase now

Scale

Skills@Scale

Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

Upcoming Public Classes

Questions?

If you have any questions, please refer to our Frequently Asked Questions page.