SQL interface

The SQL interface reads your stored test and telemetry data directly, with ordinary read-only SELECT statements sent over HTTP or from a Postgres client. It queries the same data that backs Nominal, so the datasets, assets, runs, and events you already work with in the app are the tables you query here, without copying anything out or standing up a separate data warehouse.

That makes it the path to take when you want data in your own tools: pull a channel into a notebook, feed a dashboard, or run a scheduled check.

Once a query returns what you’re after, a companion export endpoint runs it again unbounded and writes the whole result to a file for download.

• Quickstart: in the browser

• Quickstart: from code

• Schema

Next steps

• SQL console quickstart: run your first query in the browser.

• SQL REST API quickstart: run your first query from code.

• Postgres clients: connect with JDBC, MATLAB, psycopg, or tokio-postgres.

• Python with Ibis: build queries as Python expressions instead of SQL strings.

• Writing queries: scoping, limits, and query patterns.

• Schema: the tables you can query, and the function allowlist.

• SQL REST API: the endpoint contract and error codes.

• SQL REST API quickstart
• Postgres clients
• Python with Ibis
• Writing queries