POST
/
data
/
projects
/
{projectId}
/
queries
curl --request POST \
  --url https://partner.peaka.studio/api/v1/data/projects/{projectId}/queries \
  --header 'Content-Type: application/json' \
  --data '{
  "displayName": "sampleQuery",
  "inputQuery": "SELECT * from \"mycatalog\".payment.customers"
}'

Path Parameters

​
projectId
string
required

Body

application/json
​
displayName
string

The display name of the query.

​
inputQuery
string

The sql query.

​
queryType
string

The type of the query: PLAIN or MATERIALIZED

Default is PLAIN.

​
schedule
object

This class represents a schedule for a materialized query.

Response

200 - application/json
​
displayName
string

The display name of the query.

​
id
string

The ID of the query.

​
inputQuery
string

The sql query.

​
inputQueryRefId
string

The reference id of the input query.

​
name
string

The name of the query.

This is the name of the query which will be used in the sql query. e.g. SELECT * FROM "peaka"."query"."<name>"

​
queryType
string

The type of the query: PLAIN or MATERIALIZED

​
schedule
object

This class represents a schedule for a materialized query.