Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 Postgres 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 |
|---|---|
| Child instances | Create point-in-time copies 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. |
| Monitoring and observability | Monitor your database performance and health using built-in metrics and logging. |