Execute SQL query
POST
/dataset-tables/{tableId}/query
Parameters
Section titled “ Parameters ”Path Parameters
Section titled “Path Parameters ” tableId
required
string
Request Body
Section titled “Request Body ”object
sql
required
string
maxRows
integer
includeStats
boolean
Responses
Section titled “ Responses ”Query executed successfully
object
queryId
required
string
columns
required
Array<object>
object
name
required
string
type
required
string
rows
required
Array<object>
object
key
additional properties
rowCount
required
number
truncated
required
boolean
stats
object
executionTimeMs
required
number
planningTimeMs
number
bytesScanned
number
rowsScanned
number
usage
object
getOptsCold
required
number
getOptsWarm
required
number
getRangeCold
required
number
getRangeWarm
required
number
getRangesCold
required
number
getRangesWarm
required
number
headCold
required
number
headWarm
required
number
listCold
required
number
listWarm
required
number
putOperations
required
number
deleteOperations
required
number
cacheHitRatePercent
required
number
readBytesCold
required
number
readBytesWarm
required
number
writeBytes
required
number
Bad request - invalid SQL or query error
Forbidden - insufficient permissions
Dataset table not found