cancel
Showing results for 
Search instead for 
Did you mean: 
Lakebase Discussions
Ask questions, share challenges, and connect with others working on Lakebase. From troubleshooting to best practices, this is where conversations happen.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

jeremiasInetum
by • New Contributor II
  • 401 Views
  • 4 replies
  • 4 kudos

Lakebase Postgres branch stuck "disabled" after auto-archive → unarchive (Public Preview)

Hi all,Running into what looks like a platform bug with Lakebase Postgres (Public Preview) and hoping a community engineer can help, since my Databricks support case (#01009170) was closed as out of entitlement (personal account, no support contract)...

  • 401 Views
  • 4 replies
  • 4 kudos
Latest Reply
Albert_PKW
New Contributor II
  • 4 kudos

I also faced the same error as @jeremiasInetum. So I applied the steps from @Gokul_Pillai1  and status.disabled became false. After that, I navigate to branches in Lakebase. In branch overview, click on Protect button under Disable archiving.Click Se...

  • 4 kudos
3 More Replies
KeatOoi
by • New Contributor II
  • 420 Views
  • 4 replies
  • 0 kudos

Lakebase Data API – First Request Times Out After 8 Seconds When Compute Is Offline

Hi Everyone,I’m using the Databricks Lakebase Data API and have noticed that the first API call consistently times out after approximately 8 seconds when the Lakebase compute is offline.The first request triggers the compute to start, and the compute...

  • 420 Views
  • 4 replies
  • 0 kudos
Latest Reply
AbhilashNagilla
Databricks Employee
  • 0 kudos

The Data API connects as the authenticator role, which then assumes the requesting user's identity. PostgreSQL loads a role's configuration defaults only at login; SET ROLE and SET SESSION AUTHORIZATION do not load them, and a role-level setting outr...

  • 0 kudos
3 More Replies
batch_bender
by • New Contributor III
  • 711 Views
  • 1 replies
  • 2 kudos

Resolved! Lakebase synced table doesn’t recognize Auto CDF on a SDP materialized view

I’m trying to create a triggered Lakebase synced table from a SDP-created materialized view.The source MV uses Automatic CDF: row tracking is enabled and legacy CDF (delta.enableChangeDataFeed) is disabled. The Automatic CDF workspace preview is enab...

  • 711 Views
  • 1 replies
  • 2 kudos
Latest Reply
GabFernandes
Contributor III
  • 2 kudos

Short answer: No — Lakebase synced tables in Triggered/Continuous mode do not currently support Automatic CDF from materialized views. This is a documented limitation, not a configuration issue.The synced tables documentation explicitly states:"Sourc...

  • 2 kudos
charl-p-botha
by • Databricks Partner
  • 1114 Views
  • 2 replies
  • 3 kudos

Resolved! How to prevent users from creating Lakebase compute?

Dear community,According to [1] and other sources, all workspace users are assigned `CAN_CREATE` on lakebase projects, and this permission "can't be revoked".The problem is that such a project comes with by default a 8 - 16 CU lakebase compute instan...

  • 1114 Views
  • 2 replies
  • 3 kudos
Latest Reply
charl-p-botha
Databricks Partner
  • 3 kudos

Thank you very much for also looking into this.I've submitted this as feedback via the new Lakebase Postgres web-ui. It doesn't look like I can link to that submitted feedback here. Let's hope for the best.

  • 3 kudos
1 More Replies
smithsonian
by • Contributor
  • 4656 Views
  • 4 replies
  • 0 kudos

Resolved! Controlling Agent access to Tools and Tool access to Data Operations

I am building an agentic workflow.  This is a multi agent workflow - Plan, Reason, Act and Synthesize. Each agent has its own access to tools to take ACTIONS on data. Some of these agents are READ only, some can WRITE/UPDATEAll data is resident withi...

  • 4656 Views
  • 4 replies
  • 0 kudos
Latest Reply
venkat-raghavan
New Contributor III
  • 0 kudos

Hi Ashwin I do want to contrast you stated really well from what is stated or implied in the Service Control policies documentation you shared.You said things1) For write or move actions, I would strongly recommend a controlled execution pattern... p...

  • 0 kudos
3 More Replies
POCUSER
by • New Contributor III
  • 1528 Views
  • 1 replies
  • 0 kudos

Resolved! Lakebase Data API private access with Public Network Access disabled

We are testing Azure Databricks Lakebase Autoscaling with Public Network Access disabled and standard inbound Private Link enabled.The workspace UI works privately through VPN, but the Lakebase Data API hostname still resolves to a public IP and retu...

  • 1528 Views
  • 1 replies
  • 0 kudos
Latest Reply
stbjelcevic
Databricks Employee
  • 0 kudos

Hi @POCUSER , Yes, the Lakebase Data API can be used privately with Public Network Access disabled. Because the Data API is a REST endpoint (Lakebase Data API), it goes through your workspace’s standard inbound (front-end) Private Link, the databrick...

  • 0 kudos
POCUSER
by • New Contributor III
  • 1793 Views
  • 2 replies
  • 0 kudos

Resolved! Inquiry regarding Query History and Audit Logs for Databricks Lakebase

We are using Lakebase Data API (HTTP Endpoint) to execute queries and need to verify the audit log capabilities for compliance. Could you please clarify:Query Text Logging: Does Databricks capture the full SQL statement text and the actual user ident...

  • 1793 Views
  • 2 replies
  • 0 kudos
Latest Reply
Ashwin_DSA
Databricks Employee
  • 0 kudos

Hi @POCUSER, I’m not aware of any public documentation that explicitly confirms that every request sent through the Lakebase Data API is captured in system.query.history or exposed through a dedicated per-request audit log. A practical way to validat...

  • 0 kudos
1 More Replies
gokkul
by • Databricks Partner
  • 4577 Views
  • 4 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...

  • 4577 Views
  • 4 replies
  • 1 kudos
Latest Reply
Abhishek_sinha
New Contributor III
  • 1 kudos

Currently, direct write-back from Lakebase PostgreSQL to Unity Catalog Delta tables is not the recommended pattern.A few points that may help:• “Sync Tables” are mainly designed for replication/read access scenarios. Databricks currently recommends a...

  • 1 kudos
3 More Replies
Gokkul007
by • New Contributor
  • 2213 Views
  • 3 replies
  • 1 kudos

How to create a lakebase table ?

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 ma...

  • 2213 Views
  • 3 replies
  • 1 kudos
Latest Reply
balajij8
Esteemed Contributor II
  • 1 kudos

You can use Lake base Autoscaling with Synced Tables.Synced tables empower you to export high quality & governed data from Lakehouse into Lake base. Its specifically designed for downstream applications requiring extreme responsiveness (sub 10ms resp...

  • 1 kudos
2 More Replies
jericksoncea
by • New Contributor III
  • 3067 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...

  • 3067 Views
  • 3 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor II
  • 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
2 More Replies
_Lilith
by • New Contributor III
  • 3415 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...

  • 3415 Views
  • 6 replies
  • 0 kudos
Latest Reply
_Lilith
New Contributor III
  • 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
5 More Replies
MrSky
by • New Contributor III
  • 1280 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

  • 1280 Views
  • 3 replies
  • 2 kudos
Latest Reply
MrSky
New Contributor III
  • 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
2 More Replies
ctgchris
by • New Contributor III
  • 1667 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

  • 1667 Views
  • 2 replies
  • 0 kudos
Latest Reply
POCUSER
New Contributor III
  • 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
1 More Replies
Lode
by • Databricks Partner
  • 3550 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...

  • 3550 Views
  • 1 replies
  • 0 kudos
Latest Reply
emma_s
Databricks Employee
  • 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