Execute SQL query

Execute a read-only SQL query against orchestration ClickHouse tables (spans, runs, batches, records).

POST /orchestration/query

Execute SQL query

cURL

curl --request POST \
  --url https://api.getcargo.io/v1/orchestration/query \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "query": "<string>"
}
'

200

{
  "rows": [
    {}
  ]
}

Authorizations

Authorization · string · header · required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Body

application/json

Request body schema.

query · string · required

A read-only SELECT statement. Available tables: logs, runs, batches, records. Results are automatically scoped to the authenticated workspace Example: "SELECT status, count() FROM runs GROUP BY status"

Maximum string length: 10000

Response

200

application/json

Successful response

rows · Rows · object[] · required

Result rows.

Show child attributes