- 3305 Views
- 3 replies
- 0 kudos
Lakebase auto start/stop
It doesn’t appear that the Lakebase OLTP instances function like Sql warehouses in the following ways:• automatically starting when initiating a connection• automatically stopping after no usage in x minutesI am wondering if others have use cases for...
- 3305 Views
- 3 replies
- 0 kudos
- 0 kudos
Lake base supports Autoscaling & Scale to Zero with Automatic Suspension & Reactivation capabilitiesAutomatic Suspension - Lake base compute automatically suspends after a period of inactivity (default is 5 minutes).Reactivation - The compute automat...
- 0 kudos
- 4671 Views
- 6 replies
- 0 kudos
Resolved! Lakebase login via REST for a service principal
Hi all,I’m trying to set up REST-based communication between my Lakebase and a REST-client.I’m following the documentation “Connecting to Lakebase via REST using a service principal” to obtain a workspace-level token. After that, I use the Lakebase D...
- 4671 Views
- 6 replies
- 0 kudos
- 0 kudos
I created a new Lakebase project to retrace all my steps. 0- I reused my service principal on the workspace1- installed databricks authentication extension: CREATE EXTENSION IF NOT EXISTS databricks_auth;2-Added the lakehouse service principal to the...
- 0 kudos
- 1525 Views
- 3 replies
- 2 kudos
Resolved! "Get Started with Lakebase" Course
Greetings,I am following course " Get Started with Lakebase Course". I got access to "Databricks Academy Labs" but I could not find documentation related to "Get Started with Lakebase Course". I appreciate any help. Thanks,Sri
- 1525 Views
- 3 replies
- 2 kudos
- 2 kudos
@Sumit_7 , Thank you for sharing the course URL. I have been working through the same course. Please refer to the 4th lesson, “Demo: Creating and Exploring a Lakebase Project.”I was not able to find any related documentation—specifically the tables d...
- 2 kudos
- 1859 Views
- 2 replies
- 0 kudos
Error on Lakebase Postgres Autoscaling Table Tab
I can't view my lakebase postgres autoscaling project's table tab.The error id is: 3760588e08b843c5a4aebac770f8e967
- 1859 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @ctgchris,I'm experiencing the same issue — unable to view the table tab on Lakebase Postgres Autoscaling. Has there been any update or resolution on this? Any workaround would be appreciated as well.Thanks!
- 0 kudos
- 4054 Views
- 1 replies
- 0 kudos
Resolved! Lakebase in an enterprise setup
Hi,Has anyone managed to get the new Lakebase autoscaling fully working in an enterprise Azure setup?We are currently facing issues when setting up Lakebase autoscaling in a Databricks environment without a public IP, where all traffic is routed priv...
- 4054 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi, so I think what is happening as different types of tools get routed to lakebase via different paths and I believe you need to open up an additional private link. The docs here explain it pretty well. https://learn.microsoft.com/en-us/azure/datab...
- 0 kudos
- 1180 Views
- 1 replies
- 0 kudos
"Unknown Error" when running simple select query in Lakebase SQL Editor
Hello! I am experiencing a confusing issue with LakeBase. I created a new project and I tried to run the example query provided in the SQL Editor to create a first table. Unfortunately, the query failed with "Unknown Error" and not further explanatio...
- 1180 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @Sbolo ,Which Lakebase are you using? Provisioned or Autoscaling? And since you also got following error:"Public access is not allowed for workspace: <id here>"I think it can be a networking issue. Try to create private endpoints and check if this...
- 0 kudos
- 1125 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...
- 1125 Views
- 1 replies
- 0 kudos
- 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
- 2177 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...
- 2177 Views
- 1 replies
- 0 kudos
- 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
- 2538 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
- 2538 Views
- 4 replies
- 0 kudos
- 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
- 2440 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.
- 2440 Views
- 3 replies
- 1 kudos
- 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
- 3793 Views
- 1 replies
- 1 kudos
Resolved! 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...
- 3793 Views
- 1 replies
- 1 kudos
- 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
- 2889 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...
- 2889 Views
- 5 replies
- 1 kudos
- 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
- 6403 Views
- 6 replies
- 7 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...
- 6403 Views
- 6 replies
- 7 kudos
- 7 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 ...
- 7 kudos
- 1315 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 ...
- 1315 Views
- 2 replies
- 1 kudos
- 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
- 2391 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...
- 2391 Views
- 2 replies
- 4 kudos
- 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
