Lakebase Discussions
Ask questions, share challenges, and connect with others working on Lakebase. From troubleshooting t...
22 Posts
Activity in Lakebase Hub
- 35 Views
- 0 replies
- 0 kudos
Ending the Developer Struggle: The Future of Fast App Development - Virtual Event (May 5–7)
Developers want to write code, not provision databases. Learn how to create and deploy apps directly on the Databricks Platform. Join us on May 5-7. In this webinar, code comes first. Watch experts from Databricks and Cursor demonstrate how to get ...
- 35 Views
- 0 replies
- 0 kudos
- 110 Views
- 1 replies
- 0 kudos
Calling a Lakebase project API directly from an web frontend
Today we have an web frontend and custom API that we call from the frontend. I can see Lakebase projects support an API and SQL over REST. And we are considering whether skipping the custom API and calling the Lakebase API directly. However I see som...
- 110 Views
- 1 replies
- 0 kudos
Latest Reply
- 0 kudos
Hi @Sega2, I don't there are many patterns or approaches published widely yet. In general, though, for production web apps, you may want to consider something like frontend --> thin backend --> Lakebase rather than calling Lakebase Data API directly ...
- 0 kudos
- 159 Views
- 1 replies
- 0 kudos
Resolved! Lakebase branches and permissions to SQL editor
Our admin created a project for lakebase branching. My user has "Can manage" permissions. I can create branches etc, however when I run something in the SQL editor i get following error:"ERROR: permission denied for schema public (SQLSTATE 42501)CREA...
- 159 Views
- 1 replies
- 0 kudos
Latest Reply
- 0 kudos
Greetings @Sega2 , I did some digging and here is what I found. Your screenshot (thanks for sharing, it was helpful) is showing a user running a Postgres CREATE TABLE statement in the Lakebase SQL Editor and hitting this error: In Lakebase, there ar...
- 0 kudos
- 269 Views
- 4 replies
- 0 kudos
Resolved! Promoting changes from dev branch to production
I am playing with branches in lakebase. I have created a dev under prod, applied som changes. How do you merge/promote the dev into prod? Have not found any things in the UI?Thanks, Thomas
- 269 Views
- 4 replies
- 0 kudos
Latest Reply
- 0 kudos
Hi @Sega2, I can help with this. Welcome to Lakebase branching. As the earlier reply mentioned, Lakebase branches use copy-on-write technology rather than Git-style merging, so the workflow for promoting changes is a bit different from what you might...
- 0 kudos
- 546 Views
- 0 replies
- 4 kudos
Lakebase Branching Meets Docker: The Migration Safety Net I Wish I Had Years Ago
Lakebase Branching Meets Docker: The Migration Safety Net I Wish I Had Years Ago Before I became a Solutions Architect at Databricks, I was a backend software engineer and for a few years of my past life, I found myself BFF's with our BFF(backend-for...
- 546 Views
- 0 replies
- 4 kudos
- 464 Views
- 3 replies
- 1 kudos
How to access a delta table in UC from lakebase postgres ?
Hi DB Community ,Is there any way to access/write to delta table in UC from lakebase postgres ? There's a way using "Sync Table" - but it is recommended only to read data from Sync Table . Databricks recommends against writing to sync table . Or else...
- 464 Views
- 3 replies
- 1 kudos
Latest Reply
- 1 kudos
Hi @gokkul, There are a few different patterns here depending on which direction you need data to flow. Let me break them down. READING DELTA/UC DATA FROM LAKEBASE (UC to Postgres) Synced tables are the primary mechanism for this. They automatically ...
- 1 kudos
- 726 Views
- 3 replies
- 0 kudos
Lakebase not accessible in Private Network
We have a VNET Injected workspace in Azure. There are multiple SQL Warehouse which are easily accessible from Private Network - both directly from VM and via VPN on client's machine. We deployed Lakebase. Inside the Workspace, connectivity is working...
- 726 Views
- 3 replies
- 0 kudos
Latest Reply
- 0 kudos
Summary Lakebase operates in the Databricks Serverless compute plane, meaning it does not reside inside your injected VNET. Connection timeouts from external tools are typically caused by blocked outbound ports or missing front-end Private Link confi...
- 0 kudos
- 479 Views
- 3 replies
- 1 kudos
Resolved! Lakebase error logs
Anyone know where to see any logs related to Lakebase/Postgres? I have a Tableau Prep flow that is failing but the error is not clear and I'm trying to find out what the database is capturing.
- 479 Views
- 3 replies
- 1 kudos
Latest Reply
- 1 kudos
There are multiple ways of monitoring Lakebase errors and warnings. This will let you see what Tableau is actually sending and how it behaves (e.g., repeated failing INSERT). 3. Control‑plane / audit logs for Lakebase Databricks audit logs include...
- 1 kudos
- 360 Views
- 1 replies
- 1 kudos
Databricks App how to setup lakebase postgres connection locally
I'm developing a FastAPI middleware app (Databricks App) that connects to both a SQL Warehouse (Unity Catalog) and a Lakebase PostgreSQL instance using async SQLAlchemy. The app works perfectly when deployed to Databricks, but I'm trying to set up lo...
- 360 Views
- 1 replies
- 1 kudos
Latest Reply
- 1 kudos
Summary You should be able to test your FastAPI endpoints locally. Lakebase supports direct external connections via the standard PostgreSQL wire protocol, meaning your local SQLAlchemy setup can directly query the Lakebase instance without needing t...
- 1 kudos
- 456 Views
- 1 replies
- 3 kudos
Lakebase & the Evolution of Data Architectures
One of the most interesting shifts in the Databricks ecosystem is Lakebase.For years, data architectures have enforced clear boundaries:OLTP → Operational databasesOLAP → Analytical platformsETL → Bridging the gapWhile familiar, this model often crea...
- 456 Views
- 1 replies
- 3 kudos
Latest Reply
- 3 kudos
Exactly. As I'm sure you are aware there is already a great "sync" from Delta -> Postgres but coming soon is gonna be a seamless way to do the opposite (Yes, even simpler than the version of this that was in private preview). If I had a moving visual...
- 3 kudos
- 502 Views
- 5 replies
- 1 kudos
Resolved! Disable Lakebase and Model Serving (Foundation Models) at Account and/or Workspace level
Hello Databricks Support Team,we would like to understand whether it is possible to disable specific Databricks product capabilities in our environment, both at Account level and at Workspace level.1) LakebaseWe would like to confirm if Databricks L...
- 502 Views
- 5 replies
- 1 kudos
Latest Reply
- 1 kudos
Got it . Since Lakebase went GA recently its enabled by default now . You will need to open a support ticket to disable it . https://docs.databricks.com/aws/en/resources/support
- 1 kudos
- 715 Views
- 6 replies
- 4 kudos
Resolved! How to use Row Level Security on a Sync table in Lakebase
Hi,Im trying to test some stuff out with the Databricks Lakebase, i want to connect the Lakebase to our custom frontend application. Using lakebase, since it is postgres based should result in faster query performance. I created a synced table to syn...
- 715 Views
- 6 replies
- 4 kudos
Latest Reply
- 4 kudos
Hi @Jeffrey- Short answer: you’re not doing anything wrong—this is expected with Lakebase synced tables. UC row filters/masks don’t apply to Lakebase synced tables yet; RLS must be defined on the Postgres side separately. Synced tables are owned in ...
- 4 kudos
- 191 Views
- 2 replies
- 1 kudos
Resolved! Is it possible to have Lakebase Postgres as a compute option for an AI/BI Dashboard?
Can dashboards be powered by Lakebase Postgres?I noticed I can select it in the 'Queries' editor, but it doesn't seem to be an option for dashboards, which currently only shows SQL Warehouse and Serverless.Any way around this?Our aim is to support a ...
- 191 Views
- 2 replies
- 1 kudos
Latest Reply
- 1 kudos
You can register Lakebase as read-only foreign catalog. In this case both computes will be used ( Sql end point and Lakebase). Doing lots of entitlement filtering via ABAC policies when dashboard being used can be tricky. Pre aggravated MV can be a c...
- 1 kudos
- 195 Views
- 0 replies
- 1 kudos
Data Activation : RETL on Databricks Lakebase
Delivering Lakehouse insights into external operational applications has been a headache for low latency cases. This often required complex & brittle integrations. With Databricks Lakebase Synced Tables, a native solution for Reverse ETL bridges the ...
- 195 Views
- 0 replies
- 1 kudos
- 572 Views
- 2 replies
- 4 kudos
Resolved! BUG: Agent deployment fails with PERMISSION_DENIED for Lakebase dependency when created via databric
SummaryWe are encountering a PERMISSION_DENIED error when deploying a Databricks Agent that uses Lakebase for agent memory, even though the endpoint creator has all documented permissions.The failure happens during serving endpoint creation, which is...
- 572 Views
- 2 replies
- 4 kudos
Latest Reply
- 4 kudos
Can you check the MLFlow version you are using . https://docs.databricks.com/aws/en/generative-ai/agent-framework/agent-authentication#supported-resources-for-automatic-authentication-passthrough
- 4 kudos
