Query data
Query Altertable from the UI, SQL clients, APIs, and AI tools. Every query runs against the same lakehouse namespace, so Altertable catalogs, object-storage mappings, external catalogs, and product analytics data can be joined in one place.
HTTP API
Run SQL against Altertable through the HTTP query endpoint and stream lakehouse results into applications and scripts.Object Storage
Query files and Iceberg datasets in S3-compatible object storage from Altertable without moving data into another system.DuckDB
Query Altertable databases from DuckDB with the community extension and work with lakehouse data from local SQL workflows.Pandas, Polars, and Ibis
Query Altertable tables with Pandas, Polars, or Ibis using DuckDB's Python client and the Altertable community extension.SQL Explorer
Explore Altertable data with SQL, browse catalogs, run DuckDB-powered queries, and inspect results from your lakehouse.Ask Agent
Ask questions about your Altertable data with an agent that uses shared lakehouse context, SQL, and saved business definitions.Visualizations
Build insights and dashboards in Altertable to analyze lakehouse data, monitor KPIs, and share trusted results.Model Context Protocol (MCP)
Connect MCP-compatible AI clients to Altertable so agents can query lakehouse data through governed, scoped tools.Adapters
Connect SQL clients and data tools to Altertable through Postgres-compatible access and Arrow Flight SQL interfaces.Integrations
Connect BI tools, SQL clients, and AI agents to Altertable so every workflow can query the same lakehouse data.Altertable CLI
Use the Altertable CLI to query lakehouse data, load files, and automate workflows from the terminal.Product Analytics
Analyze product behavior in Altertable with funnels, retention, segmentation, dashboards, and SQL over lakehouse data.OpenTelemetry
Query OpenTelemetry logs and traces from Grafana or Altertable Explore, alongside product, operational, and business data.