API ReferenceGuidesChangelog
Analytics

Execute SQL

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

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

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" \  -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  },  "error": "string",  "result": {    "columnTypes": {      "property1": "STRING",      "property2": "STRING"    },    "columns": [      "string"    ],    "cursor": "string",    "generatedAt": "2019-08-24T14:15:22Z",    "rows": [      {}    ]  },  "runtimeCost": "string"}