Lakebase Articles
A structured knowledge hub for Lakebase. Find in-depth technical content, how-to guides, and referen...
42 Posts
Activity in Lakebase Hub
- 96 Views
- 0 replies
- 0 kudos
Announcement | Lakebase and Agentic SDLC: Branching Databases for Coding Agents
As coding agents work in parallel, shared development databases can become a bottleneck. Lakebase database branching gives each agent or pull request an isolated Postgres environment for schema changes, testing, and preview workflows, without affecti...
- 96 Views
- 0 replies
- 0 kudos
- 151 Views
- 0 replies
- 0 kudos
Announcement | Load terabytes of data in minutes into Lakebase Postgres
Lakebase Postgres uses the Lake Transactional/Analytical Processing (LTAP) architecture to offload heavy bulk operations from primary compute to distributed engines such as Spark. This helps teams load large lakehouse datasets into Lakebase while kee...
- 151 Views
- 0 replies
- 0 kudos
- 985 Views
- 1 replies
- 1 kudos
Resolved! Group-based auth with Lakebase Data API
While Lakebase supports group-based authentication, this doesn't seem to have carried over to Lakebase Data API.Here, we must assign on the individual user or service principal,Create principalSetup authenticator accessSchema- and table grantsThis me...
- 985 Views
- 1 replies
- 1 kudos
Latest Reply
- 1 kudos
Hi Malthe, you're right, the Data API doesn't support group roles yet. The reason is how it authenticates. Over a normal Postgres connection you can log in as a group role (created with `databricks_create_role('<group>', 'GROUP')`). The Data API work...
- 1 kudos
- 238 Views
- 0 replies
- 0 kudos
Announcement | Lakebase Search: State-of-the-art full-text and vector search for Postgres
Lakebase Postgres now includes built-in full-text and vector search, generally available on AWS and Azure. With lakebase_vector for approximate nearest-neighbor search and lakebase_text for BM25 search, teams can run semantic, keyword, and hybrid ret...
- 238 Views
- 0 replies
- 0 kudos
- 854 Views
- 5 replies
- 5 kudos
Resolved! Lakebase Data API (GCP) returns jwk not found for valid service principal tokens
Workspace on GCP us-central1, Lakebase Autoscaling (Beta). The Data API returns 400 {"message":"jwk not found"} for every request.Setup follows the docs: role created with databricks_create_role('<sp-uuid>', 'SERVICE_PRINCIPAL'), GRANT "<sp-uuid>" TO...
- 854 Views
- 5 replies
- 5 kudos
Latest Reply
- 5 kudos
Update: resolved. Databricks confirmed this was a bug on their side in the Data API's JWKS resolution on GCP, and it has been fixed. The same requests that were failing with jwk not found now return 200 OK, with no changes to my configuration (same s...
- 5 kudos
- 814 Views
- 5 replies
- 3 kudos
Resolved! 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...
- 814 Views
- 5 replies
- 3 kudos
Latest Reply
- 3 kudos
Update on this post: I have raised a support case with Databricks and requested that the timeout be increased. The timeout has been increased to 20 seconds.
- 3 kudos
- 753 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)...
- 753 Views
- 4 replies
- 4 kudos
Latest Reply
- 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
- 279 Views
- 0 replies
- 0 kudos
Announcement | Improving Lakebase Postgres compute cache
Lakebase Postgres separates compute from durable storage, making efficient compute-side caching essential for high-throughput, low-latency workloads. In this update, we share how larger shared buffers and huge pages help keep more hot data in DRAM, w...
- 279 Views
- 0 replies
- 0 kudos
- 1146 Views
- 1 replies
- 3 kudos
Building Stateful Agents on Lakebase
TL;DR — Production agents need more than conversation history. They must survive restarts, recall decisions from earlier sessions, and work with current business data. In our Supply Chain Planner Copilot, Lakebase handles all three. The key implement...
- 1146 Views
- 1 replies
- 3 kudos
Latest Reply
- 3 kudos
Thanks for the great walkthrough, @AlexMiller. If inventory changes while a recommendation is waiting for approval, is it checked again when the run resumes? How do you decide whether the change warrants a revised plan and another review?
- 3 kudos
- 493 Views
- 0 replies
- 0 kudos
Announcement | Autoscaling Lakebase Postgres
Choosing a fixed database size before you know the workload is an old pattern. Lakebase Postgres removes that sizing exercise by continuously adjusting compute to match demand, while keeping PostgreSQL running and the data safely decoupled in the sto...
- 493 Views
- 0 replies
- 0 kudos
- 298 Views
- 0 replies
- 0 kudos
🚀 My Lakebase App is Working!
I successfully deployed my app and fixed the database permission issue.The main issue was with permissions in Overview → Roles & Database. I found a separate randomly generated role/number associated with the database, and after granting it the requi...
- 298 Views
- 0 replies
- 0 kudos
- 457 Views
- 3 replies
- 1 kudos
Lakebase Postgre updating Delta Table.
I am using Postgre for OLTP processing for POS application.Lag is reduced a lot, however when there is updation on Postgre table, I need to sync back to delta table. There is one way from delta table sync table (read only). Any design pattern sas to ...
- 457 Views
- 3 replies
- 1 kudos
Latest Reply
- 1 kudos
As @balajij8 and @srini_ve @mentioned, Lakebase CDF is the way to do it. You’ll have the change data flowing to lake house as SCD2 so you have a record of all the transactions happening in lakebase stored in your lake house. I have a LinkedIn post wr...
- 1 kudos
- 482 Views
- 0 replies
- 2 kudos
Understanding Lakebase branching
I've been playing with Databricks Lakebase lately and I'm impressed by some of the features that come with it. I mean, you can sync data from a Lakehouse to Lakebase (OLAP to OLTP) and vice versa using Lakebase CDF. But most importantly, I'm impresse...
- 482 Views
- 0 replies
- 2 kudos
- 813 Views
- 0 replies
- 0 kudos
Moving Beyond Manual Changes: A Guide to Shipping Lakebase Schema with Bundles
Moving Beyond Manual Changes: A Guide to Shipping Lakebase Schema with Bundles Lakebase is a Databricks fully managed PostgreSQL database for online transaction processing (OLTP). Declarative Automation Bundles (formerly Databricks Asset Bundles) are...
- 813 Views
- 0 replies
- 0 kudos
- 15039 Views
- 2 replies
- 8 kudos
[Partner Blog] Introduction to Databricks Lakebase: Unified OLTP+OLAP Engine for AI-Native Workloads
IntroductionMotivationWhat is Databricks Lakebase?Key FeaturesWorking with Lakebase1. Prerequisites:2. Enabling Lakebase:3.Creating a Lakebase Database:4. Authentication:5. Authorisation:6. Using Lakebase data in Analytical load (No ETL):7. Sending L...
- 15039 Views
- 2 replies
- 8 kudos
Latest Reply
- 8 kudos
Nice writeup! This unified OLTP+OLAP approach solves a lot of headaches we deal with when data is scattered across different systems. The database branching thing caught my eye - having dev environments that work like git branches is a game changer. ...
- 8 kudos
