Insights

Execute Query

Changed on

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

post/api/v1/insights/execute

Request

  • The document declares no server URL.
  • Auth
    • HTTP bearer
    • or API key in cookie __fabro_session

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
}

Changes