cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Announcements
Stay up-to-date with the latest announcements from Databricks. Learn about product updates, new features, and important news that impact your data analytics workflow.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to use Lakebase as a transactional data layer for Databricks Apps

Sujitha
Databricks Employee
Databricks Employee

Why Lakebase + Databricks Apps

Lakebase and Databricks Apps work together to simplify full-stack development on the Databricks platform:

  • Lakebase gives you a fully managed Postgres database with fast reads, writes, and updates, plus modern features like branching, and point-in-time recovery.
  • Databricks Apps provides the serverless runtime for your application frontend, with built-in identity, access control, and integration with Unity Catalog and other lakehouse components.

By combining the two, you can build interactive tools that store and update state in Lakebase, access governed data in the lakehouse, and serve everything through a secure, serverless UI, all without managing separate infrastructure. In the example below, weโ€™ll show how to build a simple holiday request approval app using this setup.

Getting Started: Build a Transactional App with Lakebase

This walkthrough shows how to create a simple Databricks App that helps managers review and approve holiday requests from their team. The app is built with Databricks Apps and uses Lakebase as the backend database to store and update the requests.

 
Screenshot 2025-08-29 at 7.18.25โ€ฏPM.png

Hereโ€™s what the solution covers:

  1. Provision a Lakebase database
    Set up a serverless, Postgres OLTP database with a few clicks.
  2. Create a Databricks App
    Build an interactive app using a Python framework (like Streamlit or Dash) that reads from and writes to Lakebase.
  3. Configure schema, tables, and access controls
    Create the necessary tables and assign fine-grained permissions to the app using the Appโ€™s client ID.
  4. Securely connect and interact with Lakebase
    Use the Databricks SDK and SQLAlchemy to securely read from and write to Lakebase from your app code.

The walkthrough is designed to get you started quickly with a minimal working example. Later, you can extend it with more advanced configuration.

Continue to read more here.

0 REPLIES 0

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now