Connecting and Authentication Patterns

Makes Lakebase connections production-grade. Following the lecture-demo pattern, learners compare OAuth tokens and native passwords, handle the 60-minute token lifetime with refresh, and build a token-refreshing connection pool in both SQLAlchemy and raw psycopg — sized against the endpoint's connection ceiling and observed through pg_stat_activity. The course concludes with the Lakebase Data API, showing how the authenticator role brokers identity via SET ROLE to enforce the same privilege model over HTTP.

Skill Level

Associate

Duration

Prerequisites

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

• Comfort reading and writing Python, including classes

• Ability to connect to Lakebase with psycopg (from LB-103)

Suggested prior course: LB-103 First Steps — establishes the basic psycopg connection this course hardens for production.

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

Autoscaling and Scale-to-Zero

Turns the compute/storage split into a cost lever. Following the lecture-demo pattern, learners diagnose a fixed-compute bill, configure the autoscaling CU range, enable scale-to-zero with the right timeout, weigh the HA cold-start trade-off, and apply per-branch configs across production, dev, and agent-test to compute the resulting monthly bill.

Paid & Subscription

Lab

Associate

Branching Workflows

Turns copy-on-write branching into everyday practice. Following the lecture-demo pattern, learners create branches four ways, recover data with point-in-time branches, manage the branch lifecycle (protect, reset, delete), and choose a branching strategy with per-workload TTLs — including branch-per-PR CI/CD. Branches are the feature that lets developers pair a code branch with a database branch. Two real OrderOps admin apps, one bound to each branch, make isolation tangible: learners edit orders in each app and prove changes never cross branches, then graduate a schema change from the dev branch to production by re-running the migration and shipping the new app version.

Paid & Subscription

Lab

Associate

Monitoring and Observability with System Tables

Comprehensive auditing, monitoring, and observability using system tables, query history analysis, and proactive alerting for DBSQL environments.

Note: Databricks Academy is transitioning to a notebook-based format for classroom sessions within the Databricks environment, discontinuing the use of slide decks for lectures. You can access the lecture notebooks in the Vocareum lab environment.

Paid & Subscription

Lab

Associate