API ReferenceGuidesChangelog
Analytics

Query SQL Result

Query the result of a SQL query by execution_id.

GET
/v1/analytics/{owner}/{slug}/sql/query_result/{executionId}

Authorization

api-key<token>

In: header

Path Parameters

owner*string

username or organization name

slug*string

project slug

executionId*string

Query Parameters

projectId?string

use project id if project_owner and project_slug are not provided

version?integer

version of the datasource, default to the active version if not provided

Formatint32

Response Body

application/json

curl -X GET "https://example.com/v1/analytics/string/string/sql/query_result/string"
{  "executionInfo": {    "computeStats": {      "binaryVersionHash": "string",      "clickhouseStats": {        "memoryUsage": "string",        "queryDurationMs": "string",        "readBytes": "string",        "readRows": "string",        "resultBytes": "string",        "resultRows": "string"      },      "computeCostMs": "string",      "computedAt": "2019-08-24T14:15:22Z",      "computedBy": "string",      "isCached": true,      "isRefreshing": true    },    "error": "string",    "executionId": "string",    "finishedAt": "2019-08-24T14:15:22Z",    "processorVersion": 0,    "queryId": "string",    "result": {      "columnTypes": {        "property1": "STRING",        "property2": "STRING"      },      "columns": [        "string"      ],      "cursor": "string",      "generatedAt": "2019-08-24T14:15:22Z",      "rows": [        {}      ]    },    "scheduledAt": "2019-08-24T14:15:22Z",    "startedAt": "2019-08-24T14:15:22Z",    "status": "PENDING"  }}