The AI-Native Data Lakehouse

A lakehouse built for 1000x more questions, simplifying fragmented data stacks with one foundation for warehouse-grade performance, storage economics, live federation, and agent-ready context.

Skip to content

Explore and query

Explore and query

Explore and query

Use SQL Explorer to inspect tables and run a first query. Use Ask Altertable when you want to explore a question with an agent.

Queries run with DuckDB SQL. Qualify tables as catalog.schema.table to join managed tables with connected sources.

For application code, use the HTTP API or SDK. For terminal workflows, use the CLI. To connect a BI tool, choose a SQL client interface.

SQL ExplorerExplore Altertable data with SQL, browse catalogs, run DuckDB-powered queries, and inspect results from your lakehouse.Query from an applicationRun SQL from application code with an Altertable SDK or HTTP request, consume streamed results, and verify authentication before querying tables.Object StorageQuery files and Iceberg datasets in S3-compatible object storage from Altertable without moving data into another system.DuckDBQuery Altertable databases from DuckDB with the community extension and work with lakehouse data from local SQL workflows.Pandas, Polars, and IbisQuery Altertable tables with Pandas, Polars, or Ibis through the DuckDB extension or the Python lakehouse client's Ibis backend.