skills.rest
ThomazRossito
ThomazRossitoCOMMUNITY
Explore all skills by this author ā†’
Websiteš•@thomazrossitoGitHub

databricks-lakebase-provisioned

Provision Databricks Lakebase Provisioned PostgreSQL instances and generate OAuth credentials.

31|18|Updated Apr 4, 2026
Search Tags:#postgresql#oauth#sdk#databricks#reverse-etl#oltp#lakebase
One-click install
npx skills add https://github.com/ThomazRossito/data-agents --skill databricks-lakebase-provisioned-thomazrossito
Or copy as Structured Prompt for Agentā–¼
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/ThomazRossito/data-agents/tree/main/skills/databricks/databricks-lakebase-provisioned
Command: npx skills add https://github.com/ThomazRossito/data-agents --skill databricks-lakebase-provisioned-thomazrossito

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Managing Databricks Lakebase Provisioned PostgreSQL instances, handling OAuth token lifecycles, and syncing data between Delta Lake and operational databases is complex and errorā€‘prone. This Skill provides clear patterns and best practices to streamline provisioning, secure connections, and reverseā€‘ETL workflows.

Core Features & Use Cases

  • Instance Management: Create, list, update, and delete Lakebase Provisioned databases via the Databricks SDK or CLI.
  • OAuth Credential Generation: Generate shortā€‘lived tokens for secure database connections, with examples for notebooks and production applications.
  • Connection Patterns: Simple psycopg scripts, tokenā€‘refreshing connection pools, and environmentā€‘variable configurations for FastAPI or other services.
  • Reverse ETL Sync: Define and manage synced tables from Delta Lake to PostgreSQL using SDK, CLI, or UI, supporting snapshot, triggered, and continuous modes.
  • Integration with Databricks Apps and MLflow: Register Lakebase as an app resource and as a model resource for automated credential provisioning.

Quick Start

Use the databricks-lakebase-provisioned skill to create a new Lakebase instance named 'test-db' and obtain its OAuth token.

Frequently Asked Questions about databricks-lakebase-provisioned

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I provision a Databricks Lakebase PostgreSQL database for OLTP workloads?ā–¼

Provision Databricks Lakebase PostgreSQL for OLTP by creating instances via the Databricks SDK or CLI, generating OAuth credentials, and configuring secure SSL connections from notebooks or production services.

How do I handle OAuth token refresh for Databricks Lakebase PostgreSQL connections?ā–¼

Handle OAuth token refresh for Databricks Lakebase PostgreSQL using token-refreshing connection pools with psycopg3 and SQLAlchemy 2.x, generating short-lived tokens for secure database connections in notebooks and applications.

What's the best way to sync Delta Lake tables to PostgreSQL using reverse ETL?ā–¼

Sync Delta Lake tables to PostgreSQL using reverse ETL by defining synced tables via Databricks SDK, CLI, or UI, supporting snapshot, triggered, and continuous sync modes between Delta Lake and operational databases.

Do I need the Databricks Python SDK to manage Lakebase Provisioned databases?ā–¼

Yes, you need the Databricks Python SDK (>=0.81.0) along with psycopg3 and SQLAlchemy 2.x to provision and manage Lakebase Provisioned PostgreSQL instances, handle OAuth token lifecycles, and configure reverse ETL workflows.

Can I register Databricks Lakebase as a resource for automated credential provisioning?ā–¼

Register Databricks Lakebase as an app resource and as a model resource for integration with Databricks Apps and MLflow, enabling automated credential provisioning for secure PostgreSQL connections.

How does connecting to Lakebase PostgreSQL from FastAPI work with environment variables?ā–¼

Connect to Lakebase PostgreSQL from FastAPI using environment-variable configurations and token-refreshing connection pools, enabling secure SSL connections with short-lived OAuth tokens for production applications.

Related Skills

Explore More Data & Analytics Skillsā†’
JingyiWngJingyiWng

databricks-lakebase-provisioned

Provision and manage Lakebase PostgreSQL databases with OAuth token authentication.

Community
Advanced
datasciencemonkeydatasciencemonkey
27

databricks-lakebase-provisioned

Provision Lakebase PostgreSQL instances with OAuth and Unity Catalog integration.

Community
Advanced
prashsubprashsub
1

genai-agents-setup

Orchestrate Databricks GenAI agent implementation with MLflow 3.0 ResponsesAgent and Genie Spaces.

Community
Advanced
m19cm19c

databricks-lakebase-provisioned

Manage Databricks Lakebase Provisioned instance lifecycles with OAuth authentication.

Community
Advanced