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 Postgres roles and the CONNECT to USAGE to table-grant ladder, add row-level security, 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), then write a federated SELECT joining Lakebase and Delta and follow it through Catalog Explorer lineage and system.access.audit.

Skill Level

Associate

Duration

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

Customer registration Partner registration

See all our registration options

Registration options

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

Self-Paced

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

Instructor-Led

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

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

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

Migrating to Lakebase

Migrates an existing Postgres workload to Lakebase. Following the lecture-demo pattern, learners use a decision matrix to confirm fit, assemble a pre-migration checklist, execute a pg_dump/pg_restore migration (and its alternatives), and design a cutover strategy with validation queries that catch subtle drift.

Paid & Subscription

Lab

Associate

Production Operations: HA, Read Replicas, Instant Restore

Hardens Lakebase for production. Following the lecture-demo pattern and framed around an incident, learners configure High Availability across zones, add read replicas and route analytical traffic to them, tune the restore window, and recover from data loss with a point-in-time branch.

Paid & Subscription

Lab

Associate

Vector Search and RAG with pgvector on Lakebase

Builds a semantic retrieval layer on pgvector inside Lakebase Postgres, taught against a live "Ask the docs" app that Classroom Setup deploys. Following the lecture-demo pattern, learners decide when pgvector beats Databricks AI Search, design a document/chunk schema, choose and build HNSW and IVFFlat indexes, generate embeddings in batch with ai_query(), and write a hybrid search combining vector similarity, a metadata filter, and full-text ranking (ts_rank_cd cover-density) in one query. An optional closing section surveys Lakebase Search (Beta) and its lakebase_text (BM25) and lakebase_vector (ANN) extensions.

Paid & Subscription

Lab

Associate