API ReferenceGuidesChangelog
Analytics

Execute SQL by Async

Execute SQL in a project asynchronously.

POST
/v1/analytics/{owner}/{slug}/sql/execute/async

Authorization

api-key<token>

In: header

Path Parameters

owner*string

username or organization name

slug*string

project slug

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

Response Body

application/json

curl -X POST "https://example.com/v1/analytics/string/string/sql/execute/async" \  -H "Content-Type: application/json" \  -d '{    "sqlQuery": {      "sql": "SELECT uniq(distinct_id) FROM `Transfer`"    }  }'
{  "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  },  "executionId": "string",  "queryId": "string",  "queueLength": 0}

Execute SQL POST

Execute SQL in a project. Go to "Data Studio" -> "SQL Editor", write your query and then click "Export as cURL" ![screenshot](https://media.githubusercontent.com/media/sentioxyz/docs/HEAD/assets/image%20(102).png) Find more: https://docs.sentio.xyz/reference/data#sql-api

Query SQL Execution Detail GET

Query the execution detail of a SQL query by execution_id.