databricks-lakebase-provisioned

What problem does it solve?

This Skill addresses the challenges of managing OLTP workloads with PostgreSQL, providing a managed solution within Databricks Lakebase that simplifies database operations and enhances application integration.

Core Features & Use Cases

• OLTP Workload Management: Offers managed PostgreSQL instances for transactional workloads, reducing the overhead of database management.
• Application Integration: Supports seamless integration with Databricks Apps and other applications through OAuth authentication and Unity Catalog.
• Reverse ETL: Enables data synchronization from Delta Lake to Lakebase for operational data needs.
• Use Case: Use this Skill to create a Lakebase instance, connect an application, and implement reverse ETL for real-time data access.

Quick Start

To create a Lakebase instance, use the following command:

from databricks.sdk import WorkspaceClient
import uuid

w = WorkspaceClient()

# Create a database instance
instance = w.database.create_database_instance(
    name="my-lakebase-instance",
    capacity="CU_1",  # CU_1, CU_2, CU_4, CU_8
    stopped=False
)
print(f"Instance created: {instance.name}")
print(f"DNS endpoint: {instance.read_write_dns}")