PostgreSQL Extensions on Lakebase
Surveys the certified Postgres extension catalog on Lakebase through a lecture-demo. Learners see how extensions are scoped, installed, and version-pinned per database, then enable and use real extensions live: pg_stat_statements for query visibility, pg_trgm for fuzzy text matching, and pgvector for similarity search with an HNSW index. The tour then turns to Lakebase Search, the agent-native retrieval layer that unlocks two more extensions (lakebase_text for BM25 keyword ranking and lakebase_vector for ANN vector search) inside the same Postgres, and closes by choosing between pgvector, Lakebase Search, and Databricks AI Search for a given retrieval workload. An optional final section covers PostGIS for geospatial.
The content was developed for participants with these skills/knowledge/abilities:
• Comfort with SQL and connecting to Lakebase (from LB-103)
• Awareness that branches isolate configuration (from LB-102 or LB-201) is helpful
Suggested prior course: LB-103 First Steps — establishes connecting and running SQL, which every extension demo builds on.
Self-Paced
Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos
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
Register nowInstructor-Led
Public and private courses taught by expert instructors across half-day to two-day courses
Register nowBlended 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 nowSkills@Scale
Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

