How to create a lakebase table ?

[Gokkul007]

Hi databricks community, 

I want to create a lakebase table that is synced with the delta table . So whenever the delta table is updated the changes should be available in lakebase table.  Now I want to create a databricks streamlit application and make the app to fetch data from the lakebase table that is synced to delta table in unity catalogue. Is it possible ?  How to proceed with implementation 

[szymon_dybczak]

Hi @Gokkul007 ,

Yes, it possible. Below you can find docs for lakebase. First read get started section:

OLTP databases - Azure Databricks | Microsoft Learn

Next, read a section that will teach you how to sync your existing delta tables to lakebase

Lastly, there are plenty of resources that show you how to integrate databricks apps with lakebase:

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

How to Build Databricks Apps with Lakebase in Minutes

Add a Lakebase resource to a Databricks app | Databricks on AWS

[Poorva21]

Yes, it’s possible to have a Lakehouse table synced with a Delta table in Unity Catalog. You have a few options:

1. Direct read: Register the Delta table in Unity Catalog and query it directly from your Streamlit app.

2. Delta Live Tables (DLT): Create a DLT pipeline that reads the Delta table and writes a managed Lakehouse table that automatically updates on changes.

3. Materialized view: Create a SQL materialized view on the Delta table and refresh it periodically.

For production with transformations, use a DLT pipeline; for simple dashboards, direct Delta read works. Streamlit can connect via Databricks SQL Connector or JDBC/ODBC to fetch the latest data.

This ensures your app always sees the updated data in near real-time.