Run SQL pivot query

Run a SQL pivot query

POST /api/v1/projects/{projectUuid}/sqlRunner/runPivotQuery

Error

A valid request URL is required to generate request examples

200

{
  "results": {
    "jobId": "<string>"
  },
  "status": "ok"
}

Path Parameters

projectUuid · string · required

Body

application/json

sql · string · required

valuesColumns · object[] · required

Show child attributes

limit · number<double>

sortOnlyColumns · object[]

Fields referenced only via sortBy that aren't on any axis or in pivot columns. Items with aggregation are metrics/table calculations merged into valuesColumns for sort-anchor CTEs; items without aggregation are dimensions that ride through group_by_query to drive column_index ORDER BY. Both are excluded from pivotDetails so they don't appear as chart series.

Option 1

Option 2

Show child attributes

metricsAsRows · boolean

When true, metrics are displayed as rows instead of columns. This affects column limit calculation - when metrics are rows, we don't need to divide the column limit by the number of metrics. Defaults to false for backward compatibility (SQL runner behavior).

sortBy · object[]

Show child attributes

groupByColumns · object[]

Show child attributes

indexColumn · object

object

object[]

Show child attributes

savedSqlUuid · string

Response

200

application/json

Success

results · object · required

Show child attributes

status · enum<string> · required

Available options: ok