Postgres, inside the lakehouse
Lakebase implementation, from the schema to the application on top
Lakebase is a fully managed serverless Postgres that Databricks runs inside the lakehouse, with compute separated from storage, database branching, point-in-time recovery and Unity Catalog governance over it. We design the schema, wire the sync to your lakehouse tables, and build the transactional application or the agent memory that runs on it.
The database is the easy half. What Lakebase actually asks for is somebody who can build the application on top of it, and that is a different trade from building pipelines.
- Who it is for
- Data and product leaders putting an operational workload on Databricks
- Bench
- 115+ engineers, 80 Databricks-certified
What we work out first
- Which workload actually belongs in Postgres rather than in a Delta table, because the answer is not everything
- What the application needs to read at request latency, and what can wait for a sync
- Where the operational data has to reconcile with the analytical copy, and who wins when they disagree
- Whether Unity Catalog governance over the Lakebase catalog matches the grants the rest of the estate uses
- What the branching workflow should be, because a database you can branch changes how a team ships
- Whether an agent needs persistent memory here, and what it is allowed to remember
What we build
- Schema design for the transactional side, sized for the access pattern rather than for the report
- Sync between Lakebase and lakehouse tables, with the direction and the freshness stated rather than assumed
- The application itself: the API, the product surface and the durable workflows behind it
- Agent persistent memory that reads through the same grants a person would
- Branching wired into the delivery pipeline, so a preview environment gets production-shaped data safely
- Point-in-time recovery and read replicas configured against a recovery objective somebody has agreed
Where we have done it
Published work, with the client named
B2B ecommerce
DealerIQ
TotalLoop moved off Cosmos DB and SQL Server onto Databricks Lakebase, converted with TechFabric Airlift and cut over in reversible waves. Its dealership sales intelligence now mines customer data straight from the lakehouse it sits beside.
Agentic GTM · Our own product
Canvass
Canvass brings account research and campaign review into a Cloudflare application. The workflow keeps campaign preparation, approval and delivery states distinct.
FAQ
Lakebase implementation: common questions
What is Databricks Lakebase?
A fully managed serverless Postgres that runs inside the Databricks platform, using open source Postgres rather than a fork or a new SQL dialect. Compute is separated from storage and scales to zero when idle, and it adds database branching, point-in-time recovery and read replicas. It registers as a catalog in Unity Catalog, so the governance you already run covers it.
What is Lakebase for?
Three things Databricks names: real-time transactional applications, persistent memory for AI agents, and operational data analytics where the operational copy and the analytical one have to stay in step. It is the operational database beside the lakehouse rather than a replacement for Delta tables.
Why do most Databricks partners struggle with Lakebase?
Because the database is the easy half. Lakebase asks somebody to build a transactional application on top of it, and that is application engineering rather than data engineering. A firm whose decade is pipelines, dashboards and models has the wrong muscle for an API under request latency, a product surface people use all day, and a workflow that must never half-complete.
Why is TechFabric a good fit for Lakebase work?
We built custom software for a decade before we went deep on Databricks, and both benches are still here: 115+ people, 80 of them Databricks-certified, average fifteen years of production experience. Lakebase sits exactly on the seam between those two things, which is an unusual place for a data consultancy to be strong and an ordinary one for us.
Should our operational database move to Lakebase?
Only where the operational and analytical copies genuinely have to reconcile, or where an application would rather read from inside the lakehouse than sync out of it. A Postgres that already works, sitting far from your Databricks estate and reconciling fine, is not a migration worth paying for. We would rather say that in the first call than after a discovery.
How does Lakebase change how we ship?
Branching is the part teams underestimate. You create an instant branch of the database for a preview environment, reset it to production data, and the usual argument about test data being unrepresentative stops happening. Teams that wire that into the delivery pipeline usually see the biggest change in cycle time come from there rather than from anything the agent does.
Can agents use Lakebase for memory?
That is one of the workloads Databricks designed it for, and the governance is the reason it is worth doing there rather than in a side database. Memory held in a Lakebase catalog registered in Unity Catalog is memory an agent reads through the same grants a person would, which is the difference between an agent you can put in front of customer data and one you cannot.
The rest of databricks
Databricks consulting
Data and engineering leaders choosing a Databricks partner
Hire Databricks engineers
Engineering and data leaders who need Databricks capacity quickly
Unity Catalog consulting
Platform and security leads who have to defend the setup to somebody else
Databricks cost optimization
Data platform leads whose Databricks bill is outgrowing the work