databricks-lakebase-provisioned

To provision Lakebase PostgreSQL for OLTP workloads, use this skill to programmatically create, update, start, stop, and delete Lakebase instances, generating OAuth tokens for secure connections. It manages the full lifecycle of your transactional database instances.

OAuth token generation for PostgreSQL connections creates short-lived tokens with built-in refresh logic for production workloads. psycopg3 and SQLAlchemy use these tokens to handle token-based authentication and establish secure SSL connections to the Lakebase instance.

Yes, you can use Databricks Lakebase for reverse ETL by setting up synced tables and registering instances in Unity Catalog. This enables seamless integration between your OLTP PostgreSQL backend and Databricks notebooks or apps.

Yes, you need the Databricks SDK for Python version 0.81.0 or higher, along with psycopg3 and SQLAlchemy, to provision Lakebase instances and handle OAuth token-based authentication and secure SSL connections.

The best way to persist LangChain agent memory is to connect your agents to a provisioned Lakebase PostgreSQL instance. This skill generates OAuth tokens and configures secure connections, providing a reliable persistent backend for agent state.

Lakebase PostgreSQL connections using short-lived OAuth tokens fail when the token expires without refresh logic. This skill implements automatic token refresh for production workloads, ensuring persistent secure SSL connections via psycopg3 and SQLAlchemy.