skills.rest
ScottHMcKean
ScottHMcKeanCOMMUNITY
Explore all skills by this author →
GitHub

databricks-lakebase-provisioned

Manage Databricks Lakebase Provisioned PostgreSQL databases for OLTP workloads.

3|Updated Jan 2, 2025
Search Tags:#database#postgresql#managed service#databricks#oltp#reverse etl
One-click install
npx skills add https://github.com/ScottHMcKean/genai_notebooks --skill databricks-lakebase-provisioned-scotthmckean
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/ScottHMcKean/genai_notebooks/tree/main/.cursor/skills/databricks-lakebase-provisioned
Command: npx skills add https://github.com/ScottHMcKean/genai_notebooks --skill databricks-lakebase-provisioned-scotthmckean

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires databricks-sdk, psycopg, sqlalchemy, and includes references (resource) components.

What problem does it solve?

This Skill provides a managed PostgreSQL database solution directly within Databricks, simplifying OLTP workloads and enabling persistent state for applications.

Core Features & Use Cases

  • Managed PostgreSQL: Fully managed, PostgreSQL-compatible database service.
  • Databricks Integration: Seamlessly integrates with Unity Catalog and Databricks Apps.
  • Use Case: Store chat history for a LangChain agent running on Databricks, or implement reverse ETL to sync data from Delta Lake to an operational PostgreSQL database for a business application.

Quick Start

Use the databricks-lakebase-provisioned skill to create a new Lakebase instance named 'my-lakebase-instance' with CU_1 capacity.

Frequently Asked Questions about databricks-lakebase-provisioned

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

FAQPage Schema
How do I run an OLTP workload with a managed PostgreSQL database inside Databricks?▼

Managed PostgreSQL for Databricks OLTP is provided by Lakebase Provisioned, a fully managed database service that handles transactional workloads directly within the Databricks environment.

Can I sync data from Delta Lake to PostgreSQL for reverse ETL in Databricks?▼

Yes, reverse ETL from Delta Lake to an operational PostgreSQL database is a supported pattern, allowing you to sync transformed warehouse data to a business application using a managed service.

What is the best way to store persistent chat history for a LangChain agent on Databricks?▼

Storing persistent chat and agent memory is handled by Lakebase Provisioned, which provides a managed PostgreSQL database to retain state for LangChain applications running on Databricks.

Does Lakebase Provisioned support Unity Catalog integration and OAuth authentication?▼

Yes, Lakebase Provisioned supports Unity Catalog integration for governance and uses OAuth token-based authentication to securely connect your managed PostgreSQL database.

How do I create a managed PostgreSQL instance in Databricks with specific capacity?▼

You can create a managed PostgreSQL instance in Databricks by specifying a name and capacity, such as creating a Lakebase instance named 'my-lakebase-instance' with CU_1 capacity.

When do I need a managed PostgreSQL service for Databricks Apps?▼

You need a managed PostgreSQL service when your Databricks Apps require persistent state, transactional data processing, or an operational database backend for business logic.

Related Skills

Explore More Software Engineering Skills→
lucaslessachaveslucaslessachaves
1

databricks-lakebase-provisioned

Provision and manage Lakebase Provisioned PostgreSQL instances with OAuth and Unity Catalog.

Community
Advanced
slysikslysik

lakebase-provisioned

Provision Lakebase Provisioned PostgreSQL instances and connect via psycopg or SQLAlchemy.

Community
Advanced
ice-droid-99ice-droid-99

databricks-lakebase-provisioned

Provision Databricks Lakebase Provisioned managed PostgreSQL instances with OAuth and SSL connections.

Community
Intermediate
LaurentPRAT-DBLaurentPRAT-DB

lakebase-provisioned

Create and connect to Lakebase Provisioned PostgreSQL databases on Databricks with Python SDK and psycopg.

Community
Intermediate