Skip to main content

Governing Lakebase: Unity Catalog + Postgres

Governs a Lakebase Postgres database with Unity Catalog without losing the Postgres access-control model underneath it. Following the lecture-demo pattern, learners start at the source with the Postgres role model and how roles are created, the CONNECT to USAGE to table-grant ladder (climbed live, including a write grant), and granting at scale with group roles. They then register the database as a read-only UC foreign catalog, compare the Unity Catalog and Postgres permission models side by side (a federated read must satisfy both), add fine-grained and row-level control at the correct layer, and finally write a federated SELECT joining Lakebase and Delta, following it through Catalog Explorer lineage and system.access.audit in an optional appendix.

Skill Level
Associate
Duration
1h
Prerequisites

The content was developed for participants with these skills/knowledge/abilities:  

• Comfort with SQL and Unity Catalog concepts (catalogs, schemas, GRANT)

• Ability to connect to a Lakebase database (from LB-103)


Suggested prior course: LB-103 First Steps — establishes a working Lakebase database to register as a foreign catalog. Prior Unity Catalog familiarity is assumed rather than taught here.

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

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.

Paid & Subscription
3h
Lab
Associate

Questions?

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