POST
/
data
/
projects
/
{projectId}
/
queries
curl --request POST \
  --url https://partner.peaka.studio/api/v1/data/projects/{projectId}/queries \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "displayName": "sampleQuery",
  "inputQuery": "SELECT * from \"mycatalog\".payment.customers"
}'
{
  "id": "<string>",
  "displayName": "<string>",
  "name": "<string>",
  "inputQuery": "<string>",
  "inputQueryRefId": "<string>",
  "queryType": "<string>",
  "schedule": {
    "expression": "<string>"
  }
}

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

​
projectId
string
required

Body

application/json
Query Request
​
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
Query created
​
id
string

The ID of the query.

​
displayName
string

The display name of the 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>"

​
inputQuery
string

The sql query.

​
inputQueryRefId
string

The reference id of the input query.

​
queryType
string

The type of the query: PLAIN or MATERIALIZED

​
schedule
object

This class represents a schedule for a materialized query.