Query your data

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.

Learn how to query and work with data in your Lakebase Postgres database. Lakebase provides several methods to access and query your data, each suited for different use cases and workflows.

Note

Before querying, make sure you've connected to your database and obtained an OAuth token for authentication.

Query methods

Lakebase provides multiple ways to query your data:

Method	Description
Query from Lakebase SQL Editor	Query directly from the Lakebase App with Postgres-native features and meta-commands.
Query from SQL Editor in Lakehouse	Query with visualizations, dashboards, and collaboration. Connect directly or via Unity Catalog.
Managing data with the Tables editor	Visually manage data and schemas with an interactive interface.
Lakebase Data API	Execute CRUD operations via HTTP requests without database clients.
Postgres clients	Connect using standard Postgres clients like psql, DBeaver, and pgAdmin.
Querying data at a point in time	Query your database as it existed at any point in the past using historical branches.

Note

The Lakebase SQL Editor runs queries directly on your Lakebase database and includes Postgres-native features like EXPLAIN/ANALYZE and meta-commands. The SQL Editor (Lakehouse) offers two ways to query: (1) connect directly to Lakebase compute for full read-write access, or (2) register your database in Unity Catalog for read-only access with federated queries. Both methods provide collaboration features, visualizations, and scheduled queries.