Home
PostHog
PostHog API — warehouse_saved_queries
PostHog API — warehouse_saved_queries
PostHog API — warehouse_saved_queries. 32 operations. Lead operation: warehouse_saved_queries. Self-contained Naftiko capability covering one Posthog business surface.
What You Can Do
GET
Environmentswarehousesavedquerieslist
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/environments/{environment-id}/warehouse-saved-queries
POST
Environmentswarehousesavedqueriescreate
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/environments/{environment-id}/warehouse-saved-queries
POST
Environmentswarehousesavedqueriesresumeschedulescreate
— Resume paused materialization schedules for multiple matviews.
/v1/api/environments/{environment-id}/warehouse-saved-queries/resume-schedules
GET
Environmentswarehousesavedqueriesretrieve
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}
PUT
Environmentswarehousesavedqueriesupdate
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}
PATCH
Environmentswarehousesavedqueriespartialupdate
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}
DELETE
Environmentswarehousesavedqueriesdestroy
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}
GET
Environmentswarehousesavedqueriesactivityretrieve
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/activity
POST
Environmentswarehousesavedqueriesancestorscreate
— Return the ancestors of this saved query.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/ancestors
POST
Environmentswarehousesavedqueriescancelcreate
— Cancel a running saved query workflow.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/cancel
GET
Environmentswarehousesavedqueriesdependenciesretrieve
— Return the count of immediate upstream and downstream dependencies for this saved query.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/dependencies
POST
Environmentswarehousesavedqueriesdescendantscreate
— Return the descendants of this saved query.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/descendants
POST
Environmentswarehousesavedqueriesmaterializecreate
— Enable materialization for this saved query with a 24-hour sync frequency.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/materialize
POST
Environmentswarehousesavedqueriesrevertmaterializationcreate
— Undo materialization, revert back to the original view.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/revert-materialization
POST
Environmentswarehousesavedqueriesruncreate
— Run this saved query.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/run
GET
Environmentswarehousesavedqueriesrunhistoryretrieve
— Return the recent run history (up to 5 most recent) for this materialized view.
/v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/run-history
GET
Warehousesavedquerieslist
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/projects/{project-id}/warehouse-saved-queries
POST
Warehousesavedqueriescreate
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/projects/{project-id}/warehouse-saved-queries
POST
Warehousesavedqueriesresumeschedulescreate
— Resume paused materialization schedules for multiple matviews.
/v1/api/projects/{project-id}/warehouse-saved-queries/resume-schedules
GET
Warehousesavedqueriesretrieve
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}
PUT
Warehousesavedqueriesupdate
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}
PATCH
Warehousesavedqueriespartialupdate
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}
DELETE
Warehousesavedqueriesdestroy
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}
GET
Warehousesavedqueriesactivityretrieve
— Create, Read, Update and Delete Warehouse Tables.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/activity
POST
Warehousesavedqueriesancestorscreate
— Return the ancestors of this saved query.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/ancestors
POST
Warehousesavedqueriescancelcreate
— Cancel a running saved query workflow.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/cancel
GET
Warehousesavedqueriesdependenciesretrieve
— Return the count of immediate upstream and downstream dependencies for this saved query.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/dependencies
POST
Warehousesavedqueriesdescendantscreate
— Return the descendants of this saved query.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/descendants
POST
Warehousesavedqueriesmaterializecreate
— Enable materialization for this saved query with a 24-hour sync frequency.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/materialize
POST
Warehousesavedqueriesrevertmaterializationcreate
— Undo materialization, revert back to the original view.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/revert-materialization
POST
Warehousesavedqueriesruncreate
— Run this saved query.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/run
GET
Warehousesavedqueriesrunhistoryretrieve
— Return the recent run history (up to 5 most recent) for this materialized view.
/v1/api/projects/{project-id}/warehouse-saved-queries/{id}/run-history
Capability Spec
naftiko: 1.0.0-alpha2
info:
label: PostHog API — warehouse_saved_queries
description: 'PostHog API — warehouse_saved_queries. 32 operations. Lead operation: warehouse_saved_queries. Self-contained
Naftiko capability covering one Posthog business surface.'
tags:
- Posthog
- warehouse_saved_queries
created: '2026-05-19'
modified: '2026-05-19'
binds:
- namespace: env
keys:
POSTHOG_API_KEY: POSTHOG_API_KEY
capability:
consumes:
- type: http
namespace: posthog-warehouse-saved-queries
baseUri: ''
description: PostHog API — warehouse_saved_queries business capability. Self-contained, no shared references.
resources:
- name: api-environments-environment_id-warehouse_saved_queries
path: /api/environments/{environment_id}/warehouse_saved_queries/
operations:
- name: environmentswarehousesavedquerieslist
method: GET
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: page
in: query
type: integer
description: A page number within the paginated result set.
- name: search
in: query
type: string
description: A search term.
- name: environmentswarehousesavedqueriescreate
method: POST
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-resume_schedules
path: /api/environments/{environment_id}/warehouse_saved_queries/resume_schedules/
operations:
- name: environmentswarehousesavedqueriesresumeschedulescreate
method: POST
description: Resume paused materialization schedules for multiple matviews.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/
operations:
- name: environmentswarehousesavedqueriesretrieve
method: GET
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: environmentswarehousesavedqueriesupdate
method: PUT
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: environmentswarehousesavedqueriespartialupdate
method: PATCH
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: false
- name: environmentswarehousesavedqueriesdestroy
method: DELETE
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-activity
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/activity/
operations:
- name: environmentswarehousesavedqueriesactivityretrieve
method: GET
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-ancestors
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/ancestors/
operations:
- name: environmentswarehousesavedqueriesancestorscreate
method: POST
description: Return the ancestors of this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-cancel
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/cancel/
operations:
- name: environmentswarehousesavedqueriescancelcreate
method: POST
description: Cancel a running saved query workflow.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-dependencies
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/dependencies/
operations:
- name: environmentswarehousesavedqueriesdependenciesretrieve
method: GET
description: Return the count of immediate upstream and downstream dependencies for this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-descendants
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/descendants/
operations:
- name: environmentswarehousesavedqueriesdescendantscreate
method: POST
description: Return the descendants of this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-materialize
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/materialize/
operations:
- name: environmentswarehousesavedqueriesmaterializecreate
method: POST
description: Enable materialization for this saved query with a 24-hour sync frequency.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-revert_materializatio
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/revert_materialization/
operations:
- name: environmentswarehousesavedqueriesrevertmaterializationcreate
method: POST
description: Undo materialization, revert back to the original view.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-run
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/run/
operations:
- name: environmentswarehousesavedqueriesruncreate
method: POST
description: Run this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-environments-environment_id-warehouse_saved_queries-id-run_history
path: /api/environments/{environment_id}/warehouse_saved_queries/{id}/run_history/
operations:
- name: environmentswarehousesavedqueriesrunhistoryretrieve
method: GET
description: Return the recent run history (up to 5 most recent) for this materialized view.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: api-projects-project_id-warehouse_saved_queries
path: /api/projects/{project_id}/warehouse_saved_queries/
operations:
- name: warehousesavedquerieslist
method: GET
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: page
in: query
type: integer
description: A page number within the paginated result set.
- name: search
in: query
type: string
description: A search term.
- name: warehousesavedqueriescreate
method: POST
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-resume_schedules
path: /api/projects/{project_id}/warehouse_saved_queries/resume_schedules/
operations:
- name: warehousesavedqueriesresumeschedulescreate
method: POST
description: Resume paused materialization schedules for multiple matviews.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-id
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/
operations:
- name: warehousesavedqueriesretrieve
method: GET
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: warehousesavedqueriesupdate
method: PUT
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: warehousesavedqueriespartialupdate
method: PATCH
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: false
- name: warehousesavedqueriesdestroy
method: DELETE
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-activity
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/activity/
operations:
- name: warehousesavedqueriesactivityretrieve
method: GET
description: Create, Read, Update and Delete Warehouse Tables.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-ancestors
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/ancestors/
operations:
- name: warehousesavedqueriesancestorscreate
method: POST
description: Return the ancestors of this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-cancel
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/cancel/
operations:
- name: warehousesavedqueriescancelcreate
method: POST
description: Cancel a running saved query workflow.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-dependencies
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/dependencies/
operations:
- name: warehousesavedqueriesdependenciesretrieve
method: GET
description: Return the count of immediate upstream and downstream dependencies for this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-descendants
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/descendants/
operations:
- name: warehousesavedqueriesdescendantscreate
method: POST
description: Return the descendants of this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-materialize
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/materialize/
operations:
- name: warehousesavedqueriesmaterializecreate
method: POST
description: Enable materialization for this saved query with a 24-hour sync frequency.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-revert_materialization
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/revert_materialization/
operations:
- name: warehousesavedqueriesrevertmaterializationcreate
method: POST
description: Undo materialization, revert back to the original view.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-run
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/run/
operations:
- name: warehousesavedqueriesruncreate
method: POST
description: Run this saved query.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
- name: body
in: body
type: object
description: Request body (JSON).
required: true
- name: api-projects-project_id-warehouse_saved_queries-id-run_history
path: /api/projects/{project_id}/warehouse_saved_queries/{id}/run_history/
operations:
- name: warehousesavedqueriesrunhistoryretrieve
method: GET
description: Return the recent run history (up to 5 most recent) for this materialized view.
outputRawFormat: json
outputParameters:
- name: result
type: object
value: $.
inputParameters:
- name: id
in: path
type: string
description: A UUID string identifying this data warehouse saved query.
required: true
authentication:
type: bearer
token: '{{env.POSTHOG_API_KEY}}'
exposes:
- type: rest
namespace: posthog-warehouse-saved-queries-rest
port: 8080
description: REST adapter for PostHog API — warehouse_saved_queries. One Spectral-compliant resource per consumed operation,
prefixed with /v1.
resources:
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries
name: api-environments-environment-id-warehouse-saved-queries
description: REST surface for api-environments-environment_id-warehouse_saved_queries.
operations:
- method: GET
name: environmentswarehousesavedquerieslist
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.environmentswarehousesavedquerieslist
with:
page: rest.page
search: rest.search
outputParameters:
- type: object
mapping: $.
- method: POST
name: environmentswarehousesavedqueriescreate
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriescreate
with:
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/resume-schedules
name: api-environments-environment-id-warehouse-saved-queries-resume-schedules
description: REST surface for api-environments-environment_id-warehouse_saved_queries-resume_schedules.
operations:
- method: POST
name: environmentswarehousesavedqueriesresumeschedulescreate
description: Resume paused materialization schedules for multiple matviews.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesresumeschedulescreate
with:
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}
name: api-environments-environment-id-warehouse-saved-queries-id
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id.
operations:
- method: GET
name: environmentswarehousesavedqueriesretrieve
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesretrieve
with:
id: rest.id
outputParameters:
- type: object
mapping: $.
- method: PUT
name: environmentswarehousesavedqueriesupdate
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesupdate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- method: PATCH
name: environmentswarehousesavedqueriespartialupdate
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriespartialupdate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- method: DELETE
name: environmentswarehousesavedqueriesdestroy
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesdestroy
with:
id: rest.id
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/activity
name: api-environments-environment-id-warehouse-saved-queries-id-activity
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-activity.
operations:
- method: GET
name: environmentswarehousesavedqueriesactivityretrieve
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesactivityretrieve
with:
id: rest.id
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/ancestors
name: api-environments-environment-id-warehouse-saved-queries-id-ancestors
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-ancestors.
operations:
- method: POST
name: environmentswarehousesavedqueriesancestorscreate
description: Return the ancestors of this saved query.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesancestorscreate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/cancel
name: api-environments-environment-id-warehouse-saved-queries-id-cancel
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-cancel.
operations:
- method: POST
name: environmentswarehousesavedqueriescancelcreate
description: Cancel a running saved query workflow.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriescancelcreate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/dependencies
name: api-environments-environment-id-warehouse-saved-queries-id-dependencies
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-dependencies.
operations:
- method: GET
name: environmentswarehousesavedqueriesdependenciesretrieve
description: Return the count of immediate upstream and downstream dependencies for this saved query.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesdependenciesretrieve
with:
id: rest.id
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/descendants
name: api-environments-environment-id-warehouse-saved-queries-id-descendants
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-descendants.
operations:
- method: POST
name: environmentswarehousesavedqueriesdescendantscreate
description: Return the descendants of this saved query.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesdescendantscreate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/materialize
name: api-environments-environment-id-warehouse-saved-queries-id-materialize
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-materialize.
operations:
- method: POST
name: environmentswarehousesavedqueriesmaterializecreate
description: Enable materialization for this saved query with a 24-hour sync frequency.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesmaterializecreate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/revert-materialization
name: api-environments-environment-id-warehouse-saved-queries-id-revert-materializatio
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-revert_materializatio.
operations:
- method: POST
name: environmentswarehousesavedqueriesrevertmaterializationcreate
description: Undo materialization, revert back to the original view.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesrevertmaterializationcreate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/run
name: api-environments-environment-id-warehouse-saved-queries-id-run
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-run.
operations:
- method: POST
name: environmentswarehousesavedqueriesruncreate
description: Run this saved query.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesruncreate
with:
id: rest.id
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/environments/{environment-id}/warehouse-saved-queries/{id}/run-history
name: api-environments-environment-id-warehouse-saved-queries-id-run-history
description: REST surface for api-environments-environment_id-warehouse_saved_queries-id-run_history.
operations:
- method: GET
name: environmentswarehousesavedqueriesrunhistoryretrieve
description: Return the recent run history (up to 5 most recent) for this materialized view.
call: posthog-warehouse-saved-queries.environmentswarehousesavedqueriesrunhistoryretrieve
with:
id: rest.id
outputParameters:
- type: object
mapping: $.
- path: /v1/api/projects/{project-id}/warehouse-saved-queries
name: api-projects-project-id-warehouse-saved-queries
description: REST surface for api-projects-project_id-warehouse_saved_queries.
operations:
- method: GET
name: warehousesavedquerieslist
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.warehousesavedquerieslist
with:
page: rest.page
search: rest.search
outputParameters:
- type: object
mapping: $.
- method: POST
name: warehousesavedqueriescreate
description: Create, Read, Update and Delete Warehouse Tables.
call: posthog-warehouse-saved-queries.warehousesavedqueriescreate
with:
body: rest.body
outputParameters:
- type: object
mapping: $.
- path: /v1/api/projects/{project-id}/warehouse-saved-queries/resume-schedules
name: api-projects-project-id-warehouse-saved
# --- truncated at 32 KB (52 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/capabilities/posthog-warehouse-saved-queries.yaml