Telemetry
SQL workbench and Query API

Ask detailed questions with the same SQL humans and agents can inspect

Run DataFusion SQL over recent and historical event data, save important queries, export larger results asynchronously, and use the output in dashboards or downstream systems.

Start freeRead the documentation

Outcomes

  • Move from a high-level chart to the exact rows and fields behind it.
  • Use CTEs, joins, aggregates, percentiles, and window functions for deeper analysis.
  • Let agents generate a first query while keeping the final logic reviewable.

How it works

A reviewable workflow from signal to decision

1

Start from a decision

Write down the operational or product question before selecting columns. A focused question produces a query that can be interpreted and maintained.

2

Inspect the result, not only the syntax

Check volume, nulls, time windows, denominators, and unexpected groups. SQL can execute successfully and still answer the wrong question.

3

Save the query when it stays useful

Turn recurring analysis into a named query, dashboard widget, export, or alert so the team does not recreate it during every incident.

Capabilities

What is included

Synchronous JSON queries for interactive analysis
Asynchronous JSON and Parquet exports for larger result sets
Real-time queries that combine fresh buffered events with durable history
Read-only query validation for saved dashboard SQL
Query result charts, tables, exports, and alerts

Documentation

Query API referenceWorking with timestampsPartition columns

See the analysis

SQL recipes that use this capability

Calculate p50, p95, and p99 API Latency

Compare median and tail latency by endpoint with DataFusion-compatible percentile SQL.

Open recipe

Calculate Weekly Cohort Retention

Group users by first activity week and measure the percentage returning in later weeks.

Open recipe

Find Features Used Before Upgrade

Join feature events to upgrade events and rank behaviors that occur before paid conversion.

Open recipe

Start with one production workflow

Use a focused prompt, send synthetic events, and verify the first useful query before expanding coverage.

Open prompt pack