Sign in

v106

OpenAPI 3.1.0raw.githubusercontent.com2026-08-02160524464.6 KB
Insights

Execute Query

Executes an ad-hoc SQL query against the analytics database and returns columnar results.

post/api/v1/insights/execute

Request body

sqlstring required

SQL query to execute.

Example request

{
  "sql": "SELECT workflow_name, COUNT(*) FROM runs GROUP BY 1"
}

Response

Query results

columnsstring[] required

Column names in the result set.

elapsednumber required

Query execution time in seconds.

row_countinteger required

Number of rows returned.

Example response

{
  "columns": [
    "workflow_name",
    "count"
  ],
  "elapsed": 0.342,
  "row_count": 3
}