Lightdash home page
Search...
⌘K
Book a demo
Login
Start for free
Start for free
Search...
Navigation
SQL runner
Post apiv1projects sqlrunnerrunpivotquery
Docs
dbt guides
API
About Us
Community
Blog
API
Introduction
Reference
Projects
v2
My Account
User attributes
SSH Keypairs
SQL runner
GET
Get apiv1projects sqlrunnertables
GET
Get apiv1projects sqlrunnerfields
POST
Post apiv1projects sqlrunnerrun
POST
Post apiv1projects sqlrunnerrunpivotquery
GET
Get apiv1projects sqlrunnerresults
GET
Get apiv1projects sqlrunnersaved
DEL
Delete apiv1projects sqlrunnersaved
PATCH
Patch apiv1projects sqlrunnersaved
GET
Get apiv1projects sqlrunnersavedslug
GET
Get apiv1projects sqlrunnersavedslug results job
GET
Get apiv1projects sqlrunnersaved results job
POST
Post apiv1projects sqlrunnersaved
POST
Post apiv1projects sqlrunnerrefresh catalog
POST
Post apiv1projects sqlrunnervirtual view
PUT
Put apiv1projects sqlrunnervirtual view
DEL
Delete apiv1projects sqlrunnervirtual view
POST
Post apiv1projects sqlrunnerpreview
POST
Post apiv1projects sqlrunnerpull request
Spotlight
Spaces
Roles & Permissions
Integrations
Share links
Schedulers
Exploring
Charts
Content
Organizations
Notifications
Metrics Explorer
User Groups
API Reference
Git Integration
Dashboards
Exports
Comments
Catalog
Query
200
default
Copy
Ask AI
{
"results"
: {
"jobId"
:
"<string>"
},
"status"
:
"ok"
}
SQL runner
Post apiv1projects sqlrunnerrunpivotquery
POST
/
api
/
v1
/
projects
/
{projectUuid}
/
sqlRunner
/
runPivotQuery
Try it
200
default
Copy
Ask AI
{
"results"
: {
"jobId"
:
"<string>"
},
"status"
:
"ok"
}
Path Parameters
projectUuid
string
required
Body
application/json
sql
string
required
valuesColumns
object[]
required
Show child attributes
limit
number
sortBy
object[]
Show child attributes
groupByColumns
object[]
Show child attributes
indexColumn
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
Raise issue
Post apiv1projects sqlrunnerrun
Get apiv1projects sqlrunnerresults
Assistant
Responses are generated using AI and may contain mistakes.