Lakebase Postgres
Lakebase Postgres is a fully managed, cloud-native PostgreSQL database that brings online transaction processing (OLTP) capabilities to the Lakehouse.
Choose your version
Two versions of Lakebase Postgres are available.
Version | Description |
|---|---|
Modern database capabilities with autoscaling. The new version of Lakebase. Fully managed PostgreSQL, supported on AWS. 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. | |
Provisioned compute version. Fully managed PostgreSQL, supported on AWS and Azure. Organizes resources as database instances. You manually scale compute capacity based on your workload needs. Supports high availability (HA) and Databricks integrations not yet available in Lakebase Autoscaling. 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.
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
- Azure support (Lakebase Autoscaling is AWS only)
For detailed feature differences including platform integrations, see the Feature comparison table above and Lakebase Autoscaling limitations.