Create and organize objects in Unity Catalog

Intermediate
Data Engineer
Azure Databricks

Unity Catalog's three-layer namespace—catalogs, schemas, and objects—provides a flexible foundation for organizing data assets while maintaining centralized governance. This module explores how to create catalogs for environment isolation, organize schemas within those catalogs, and create tables, views, and volumes for structured and unstructured data. You'll learn to implement foreign catalogs for external database access, apply effective naming conventions, and configure AI/BI Genie instructions to enhance data discoverability.

Learning objectives

By the end of this module, you'll be able to:

  • Apply effective naming conventions for Unity Catalog objects
  • Create catalogs and schemas to organize data assets across environments
  • Create managed and external tables, views, and volumes in Unity Catalog
  • Implement DDL operations including functions and stored procedures
  • Implement foreign catalogs to access external database systems
  • Configure AI/BI Genie instructions for natural language data discovery

Prerequisites

The following prerequisites should be completed:

  • Basic understanding of Azure Databricks workspaces
  • Familiarity with Unity Catalog fundamentals and governance concepts
  • Knowledge of SQL and data organization principles