API Documentation
Projects -> Api Key
Connections
Data -> Catalogs
Data -> Internal Tables
Data -> Queries
Data -> Semantic Catalogs
Data -> Cache
Embedded Peaka Api
Supported Drivers
Data -> Metadata
- PUTUpdate Metadata
- PUTUpdate Relation From Metadata
- DELDelete Relation From Metadata
- PUTGenerate categorical values from the the column.
- POSTGenerate semantics for the table
- POSTAdd Relation To Metadata
- GETList of golden sqls for the project.
- POSTCreate golden sql for the project
- GETGet Project Metadata
- GETGet Project Catalog Metadata Relations
- GETGenerate sample ai questions for the project
- DELDelete golden sql from the project.
List Queries
GET
/
data
/
projects
/
{projectId}
/
queries
curl --request GET \
--url https://partner.peaka.studio/api/v1/data/projects/{projectId}/queries
[
{
"id": "709891320440684892",
"displayName": "sample2",
"name": "sample2",
"inputQuery": ""
},
{
"id": "702142445051183684",
"displayName": "deneme",
"name": "deneme",
"inputQuery": "SELECT count(*) from \"examplestripecatalogname\".\"payment\".\"customers\""
},
{
"id": "709891051854233848",
"displayName": "sample",
"name": "sample",
"inputQuery": ""
},
{
"id": "709922802836177297",
"displayName": "sampleQuery",
"name": "samplequery",
"inputQuery": "SELECT * from \"mycatalog\".payment.charges"
}
]
Path Parameters
Response
200 - application/json
Query created
The ID of the query.
The display name of the query.
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>"
The sql query.
The reference id of the input query.
The type of the query: PLAIN or MATERIALIZED
This class represents a schedule for a materialized query.
The expression of the schedule. The expression is a duration in ISO-8601 format. "PT15M" -- parses as "15 minutes" (where a minute is 60 seconds) "PT10H" -- parses as "10 hours" (where an hour is 3600 seconds) "P2D" -- parses as "2 days" (where a day is 24 hours or 86400 seconds)
curl --request GET \
--url https://partner.peaka.studio/api/v1/data/projects/{projectId}/queries
[
{
"id": "709891320440684892",
"displayName": "sample2",
"name": "sample2",
"inputQuery": ""
},
{
"id": "702142445051183684",
"displayName": "deneme",
"name": "deneme",
"inputQuery": "SELECT count(*) from \"examplestripecatalogname\".\"payment\".\"customers\""
},
{
"id": "709891051854233848",
"displayName": "sample",
"name": "sample",
"inputQuery": ""
},
{
"id": "709922802836177297",
"displayName": "sampleQuery",
"name": "samplequery",
"inputQuery": "SELECT * from \"mycatalog\".payment.charges"
}
]