Query your data
Lakebase Autoscaling is available in the following regions: us-east-1, us-east-2, eu-central-1, eu-west-1, eu-west-2, ap-south-1, ap-southeast-1, ap-southeast-2.
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.
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:
-
- 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.
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.