OLTP databases

Important

This feature is in Public Preview in the following regions: westus, westus2, eastus, eastus2, centralus, southcentralus, northeurope, westeurope, australiaeast, brazilsouth, canadacentral, centralindia, southeastasia, uksouth.

Lakebase is a fully managed Postgres online transaction processing (OLTP) database engine integrated into the Databricks Data Intelligence Platform. Lakebase lets you create and manage OLTP databases stored in Databricks-managed storage, integrating with your Lakehouse for real-time transactional workloads.

Learn about Lakebase

Understand Lakebase architecture, capabilities, and limitations.

Topic	Description
What is Lakebase?	Overview of Lakebase architecture, use cases, and Databricks integration.
Database instance architecture	Learn about database instance components, capabilities, and limitations.
Database role types and permissions	Understand the different Postgres roles and their privileges in Lakebase.
PostgreSQL compatibility	Learn about PostgreSQL compatibility, limitations, and optimization tips.

Get started with Lakebase

For database owners and admins

If you're setting up a new Lakebase database for your team:

Task	Description
Create a database instance	Set up your first Lakebase Provisioned database.
Add users and set permissions	Give other users access to your database and control what they can do.

For database users

If you need to access an existing Lakebase database:

Task	Description
Connect to your database	Get the credentials you need to access your Lakebase database.
Query your data	Use various tools to query your PostgreSQL data including SQL editor, notebooks, and psql client.

Data integration and synchronization

Connect Lakebase with your existing Databricks data and workflows.

Topic	Description
Register with Unity Catalog	Optionally register your PostgreSQL database as a catalog in Unity Catalog for federated queries.
Sync data from Unity Catalog tables	Create synced tables that automatically synchronize data from Unity Catalog tables to your Lakebase database instance.

Advanced features

Explore advanced capabilities for production workloads and enterprise use cases.

Topic	Description
Restore data and time travel	Use child instances to perform time travel and restore data to specific points in time for data recovery, compliance auditing, and development environments.
Monitoring and observability	Monitor your database performance and health using built-in metrics and logging.

Advanced configuration

Explore advanced capabilities for production workloads and enterprise use cases.

Topic	Description
High availability	Configure high availability for your database instances to ensure business continuity.
Restore window	Set the restore window for your database instance for point-in-time recovery.