Query data
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 APIFeaturedRun SQL against Altertable through the HTTP query endpoint and stream lakehouse results into applications and scripts.Altertable CLIBest DXUse the Altertable CLI to query lakehouse data, load files, and automate workflows from the terminal.DuckDBSQL-nativeQuery Altertable databases from DuckDB with the community extension and work with lakehouse data from local SQL workflows.Ask AgentTop ChoiceAsk questions about your Altertable data with an agent that uses shared lakehouse context, SQL, and saved business definitions.Model Context Protocol (MCP)FeaturedConnect MCP-compatible AI clients to Altertable so agents can query lakehouse data through governed, scoped tools.Object StorageQuery files and Iceberg datasets in S3-compatible object storage from Altertable without moving data into another system.Pandas, Polars, and IbisQuery Altertable tables with Pandas, Polars, or Ibis using DuckDB's Python client and the Altertable community extension.SQL ExplorerExplore Altertable data with SQL, browse catalogs, run DuckDB-powered queries, and inspect results from your lakehouse.Product AnalyticsAnalyze product behavior in Altertable with funnels, retention, segmentation, dashboards, and SQL over lakehouse data.OpenTelemetryQuery OpenTelemetry logs and traces from Grafana or Altertable Explore, alongside product, operational, and business data.VisualizationsBuild insights and dashboards in Altertable to analyze lakehouse data, monitor KPIs, and share trusted results.AdaptersConnect SQL clients and data tools to Altertable through Postgres-compatible access and Arrow Flight SQL interfaces.IntegrationsConnect BI tools, SQL clients, and AI agents to Altertable so every workflow can query the same lakehouse data.