Analytics

Query your data and build reporting on top of it, through the three-tier pipeline the product itself uses: datasets (saved read-only SELECTs), charts (server-side aggregations over a dataset) and dashboards (compositions of charts). You can also run ad-hoc SQL, generate SQL from a natural-language question, and read the grounded data model — real tables, enum values and custom-field references — before you write a query.

📄️ Run a read-only SQL query (ad-hoc or saved dataset)

Run a read-only query and get rows back.

📄️ Run a chart's server-side aggregation

Run a chart's server-side aggregation and return the data it would plot.

📄️ Natural-language → grounded, validated SQL

Turn a natural-language `question` into grounded, validated, read-only SQL —

📄️ The org's grounded analysis data model (schema + enums + joins + custom-field refs)

Return your organization's analysis data model — the grounded schema the

📄️ List queryable databases (org DB + external DB integrations)

List every database you can query: your organization's own database plus each

📄️ List tables available for analytics

List the tables available to query, with their columns.

📄️ Get a table's columns + types

Describe one table: its columns and their types.

📄️ Preview the first rows of a table

Preview the first rows of a table so you can see the shape of real values

📄️ List saved datasets

List your organization's saved datasets.

📄️ Create a dataset from a read-only SELECT

Save a read-only SELECT as a reusable dataset.

📄️ Get a dataset (SQL + column manifest)

Fetch one dataset with its SQL and its column manifest.

📄️ Update a dataset

Update a dataset's `name`, `description`, `sql` or `is_shared` flag.

📄️ Delete a dataset (charts cascade)

Delete a dataset.

📄️ List charts (optionally by dataset)

List your organization's charts.

📄️ Create a chart on a dataset

Create a chart on top of a dataset.

📄️ Get a chart

Fetch one chart: its type, the dataset it reads and its full `chart_config`.

📄️ Update a chart

Update a chart's `name`, `chart_type`, `chart_config`, `query_id` or

📄️ Delete a chart

Delete a chart.

📄️ List dashboards

List your organization's dashboards.

📄️ Create a dashboard from charts

Create a dashboard composing charts that already exist.

📄️ Get a dashboard + its charts

Fetch one dashboard together with the charts it contains.

📄️ Update a dashboard

Update a dashboard's `name`, `description`, `layout`, `chart_ids` or

📄️ Delete a dashboard

Delete a dashboard.

📄️ Get a dashboard + all chart data (batch)

Load a dashboard and every chart's plotted data in one call.