Lakebase Postgres

Lakebase Postgres is a fully managed, cloud-native PostgreSQL database that brings online transaction processing (OLTP) capabilities to the Lakehouse.

Important

Lakebase Autoscaling is in Beta in the following regions: eastus2, westeurope, westus.

Lakebase Autoscaling is the latest version of Lakebase with autoscaling compute, scale-to-zero, branching, and instant restore. For feature comparison with Lakebase Provisioned, see choosing between versions.

Important

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

Lakebase Provisioned uses provisioned compute that you manually scale. For feature comparison with the new Lakebase Autoscaling, see choosing between versions.

Choose your version

Two versions of Lakebase Postgres are available.

Version	Description
Lakebase Autoscaling	Modern database capabilities with autoscaling. The latest version of Lakebase. Fully managed PostgreSQL. Organizes resources as projects that contain branches, computes, and databases. Features autoscaling compute, branching, scale-to-zero, and instant restore. See What is Lakebase Autoscaling? for details.
Lakebase Provisioned	Provisioned compute version. Fully managed PostgreSQL. Organizes resources as database instances. You manually scale compute capacity based on your workload needs. See What is Lakebase Provisioned? for details.

What's new in Lakebase Autoscaling

Lakebase Autoscaling introduces modern database capabilities designed for flexible development and cost-efficient operations:

• New Lakebase App: Redesigned interface with an intuitive project-based structure for managing database resources
• Autoscaling: Compute resources automatically adjust based on workload demand. Learn more: Autoscaling
• Scale-to-zero: Computes automatically suspend after inactivity, waking up in seconds when needed. Learn more: Scale to zero
• Projects and branches: Create instant, isolated copies of your database using copy-on-write technology. Learn more: Branches
• Instant restore: Restore your database to any point in time within your configured restore window (0-30 days). Learn more: Point-in-time restore
• Read replicas: Create read-only compute endpoints that share the same storage layer, enabling instant creation without data duplication. Learn more: Read replicas
• Data API: PostgREST-compatible RESTful interface for direct HTTP access to your database. Learn more: Data API

Feature comparison

The following table compares capabilities in Lakebase Provisioned and Lakebase Autoscaling.

Note

Lakebase Autoscaling is the new version of Lakebase and is progressing toward feature parity with Lakebase Provisioned, with new feature development focused on Lakebase Autoscaling.

Feature	Autoscaling	Provisioned
Core capabilities
Provisioned (fixed-size) compute	✓	✓
Autoscaling	✓
Scale to zero	✓
Branching	✓
Instant restore	✓
Point-in-time restore	✓	✓
Read replicas	✓
High availability (readable secondaries)		✓
Data integrations
Unity Catalog registration	✓	✓
Reverse ETL (Delta -> Postgres sync)	✓	✓
Postgres -> Delta sync		✓ (Private Preview)
Query federation	✓	✓
Application integrations
Databricks Apps	Apps UI integration not supported. Use connection credentials from the Lakebase App UI. See Connection overview.	✓
Feature Store		✓
Notebooks	✓	✓
Stateful AI agents		✓
Access control
UI for Postgres role management	✓	✓
Workspace ACLs	✓	✓
Developer tools
Infrastructure as code (Asset Bundles, Terraform)	✓ (Beta)	✓
Programmatic access (REST API, CLI, SDKs)	✓ (Beta)	✓
PostgREST API support	✓ (PostgREST-compatible Data API)	✓ (Private Preview)
Cost management
Billing tags and budget policies		✓

Choosing the right version

Both versions of Lakebase are suitable for production workloads. Choose based on your feature requirements:

Choose Lakebase Autoscaling if you want:

• Compute that scales automatically based on workload demand
• Scale-to-zero for cost optimization
• Branch-based development workflows
• Instant point-in-time restore

Choose Lakebase Provisioned if you want:

• Provisioned compute that you manually scale
• High availability (readable secondaries)

For detailed feature differences including platform integrations, see the Feature comparison table above and Lakebase Autoscaling limitations.