peaka_create_query
Create a named, saved query in Peaka's semantic layer by providing a project, display name, and SQL. Optionally set a refresh schedule or query type.
Instructions
Create a named, saved query in the Peaka project's semantic layer. Returns the created query object including its ID, which can be passed to peaka_execute_query.
If you do not already know the projectId for the current task, call peaka_list_projects first and ask the user which project to use. Remember the chosen projectId for subsequent calls in this conversation.Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schedule | No | Auto-refresh schedule for MATERIALIZED queries. Use {type: 'interval', repeatDuration}, {type: 'cron', cronExpression, timezone}, or {type: 'none'} to disable an existing schedule. Ignored for PLAIN queries. | |
| projectId | Yes | The Peaka project ID to run against. | |
| queryType | No | PLAIN runs the SQL on each execute; MATERIALIZED stores results. | PLAIN |
| inputQuery | Yes | The Trino SQL body of the query. | |
| displayName | Yes | Human-readable name for the saved query. |