How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

PostHog warehouse_saved_queries API

The warehouse_saved_queries API from PostHog — 24 operation(s) for warehouse_saved_queries.

PostHog warehouse_saved_queries API is one of 139 APIs that PostHog publishes on the APIs.io network, described by a machine-readable OpenAPI specification and an AsyncAPI event-driven specification.

The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a getting-started guide, authentication docs, and an AsyncAPI specification.

This API exposes 32 operations across 24 paths, and defines 10 schemas. It is described by OpenAPI 3.2.0, at version 1.0.0.

Requests are made against a single base URL, https://app.posthog.com/api.

32 operations 24 paths 10 schemas 2 DELETE10 GET2 PATCH16 POST2 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
1.0.0
Base URL
https://app.posthog.com/api
Authentication
HTTP Bearer
Resource Areas
1

Authentication & Security 1

PostHog warehouse_saved_queries API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (PersonalAPIKeyAuth).

Paths & Operations 32

Across 24 paths, the API surfaces 32 operations — 2 DELETE, 10 GET, 2 PATCH, 16 POST, 2 PUT. Each is listed below with its method, path, parameters, and response codes.

warehouse_saved_queries 32
GET
/api/environments/{environment_id}/warehouse_saved_queries/deprecated
Create, Read, Update and Delete Warehouse Tables.
environments_warehouse_saved_queries_list 3 params → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/deprecated
Create, Read, Update and Delete Warehouse Tables.
environments_warehouse_saved_queries_create 1 param body → 201
GET
/api/environments/{environment_id}/warehouse_saved_queries/{id}/deprecated
Create, Read, Update and Delete Warehouse Tables.
environments_warehouse_saved_queries_retrieve 2 params → 200
PUT
/api/environments/{environment_id}/warehouse_saved_queries/{id}/deprecated
Create, Read, Update and Delete Warehouse Tables.
environments_warehouse_saved_queries_update 2 params body → 200
PATCH
/api/environments/{environment_id}/warehouse_saved_queries/{id}/deprecated
Create, Read, Update and Delete Warehouse Tables.
environments_warehouse_saved_queries_partial_update 2 params body → 200
DELETE
/api/environments/{environment_id}/warehouse_saved_queries/{id}/deprecated
Create, Read, Update and Delete Warehouse Tables.
environments_warehouse_saved_queries_destroy 2 params → 204
GET
/api/environments/{environment_id}/warehouse_saved_queries/{id}/activity/deprecated
Create, Read, Update and Delete Warehouse Tables.
environments_warehouse_saved_queries_activity_retrieve 2 params → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/{id}/ancestors/deprecated
Return the ancestors of this saved query. By default, we return the immediate parents. The level parameter can be used to look further back into the ancestor tree. If level overshoots (i.e. points to…
environments_warehouse_saved_queries_ancestors_create 2 params body → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/{id}/cancel/deprecated
Cancel a running saved query workflow.
environments_warehouse_saved_queries_cancel_create 2 params body → 200
GET
/api/environments/{environment_id}/warehouse_saved_queries/{id}/dependencies/deprecated
Return the count of immediate upstream and downstream dependencies for this saved query.
environments_warehouse_saved_queries_dependencies_retrieve 2 params → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/{id}/descendants/deprecated
Return the descendants of this saved query. By default, we return the immediate children. The level parameter can be used to look further ahead into the descendants tree. If level overshoots (i.e. po…
environments_warehouse_saved_queries_descendants_create 2 params body → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/{id}/materialize/deprecated
Enable materialization for this saved query with a 24-hour sync frequency.
environments_warehouse_saved_queries_materialize_create 2 params body → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/{id}/revert_materialization/deprecated
Undo materialization, revert back to the original view. (i.e. delete the materialized table and the schedule)
environments_warehouse_saved_queries_revert_materialization_create 2 params body → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/{id}/run/deprecated
Run this saved query.
environments_warehouse_saved_queries_run_create 2 params body → 200
GET
/api/environments/{environment_id}/warehouse_saved_queries/{id}/run_history/deprecated
Return the recent run history (up to 5 most recent) for this materialized view.
environments_warehouse_saved_queries_run_history_retrieve 2 params → 200
POST
/api/environments/{environment_id}/warehouse_saved_queries/resume_schedules/deprecated
Resume paused materialization schedules for multiple matviews. Accepts a list of view IDs in the request body: {"viewids": ["id1", "id2", ...]} This endpoint is idempotent - calling it on already run…
environments_warehouse_saved_queries_resume_schedules_create 1 param body → 200
GET
/api/projects/{project_id}/warehouse_saved_queries/
Create, Read, Update and Delete Warehouse Tables.
warehouse_saved_queries_list 3 params → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/
Create, Read, Update and Delete Warehouse Tables.
warehouse_saved_queries_create 1 param body → 201
GET
/api/projects/{project_id}/warehouse_saved_queries/{id}/
Create, Read, Update and Delete Warehouse Tables.
warehouse_saved_queries_retrieve 2 params → 200
PUT
/api/projects/{project_id}/warehouse_saved_queries/{id}/
Create, Read, Update and Delete Warehouse Tables.
warehouse_saved_queries_update 2 params body → 200
PATCH
/api/projects/{project_id}/warehouse_saved_queries/{id}/
Create, Read, Update and Delete Warehouse Tables.
warehouse_saved_queries_partial_update 2 params body → 200
DELETE
/api/projects/{project_id}/warehouse_saved_queries/{id}/
Create, Read, Update and Delete Warehouse Tables.
warehouse_saved_queries_destroy 2 params → 204
GET
/api/projects/{project_id}/warehouse_saved_queries/{id}/activity/
Create, Read, Update and Delete Warehouse Tables.
warehouse_saved_queries_activity_retrieve 2 params → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/{id}/ancestors/
Return the ancestors of this saved query. By default, we return the immediate parents. The level parameter can be used to look further back into the ancestor tree. If level overshoots (i.e. points to…
warehouse_saved_queries_ancestors_create 2 params body → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/{id}/cancel/
Cancel a running saved query workflow.
warehouse_saved_queries_cancel_create 2 params body → 200
GET
/api/projects/{project_id}/warehouse_saved_queries/{id}/dependencies/
Return the count of immediate upstream and downstream dependencies for this saved query.
warehouse_saved_queries_dependencies_retrieve 2 params → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/{id}/descendants/
Return the descendants of this saved query. By default, we return the immediate children. The level parameter can be used to look further ahead into the descendants tree. If level overshoots (i.e. po…
warehouse_saved_queries_descendants_create 2 params body → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/{id}/materialize/
Enable materialization for this saved query with a 24-hour sync frequency.
warehouse_saved_queries_materialize_create 2 params body → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/{id}/revert_materialization/
Undo materialization, revert back to the original view. (i.e. delete the materialized table and the schedule)
warehouse_saved_queries_revert_materialization_create 2 params body → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/{id}/run/
Run this saved query.
warehouse_saved_queries_run_create 2 params body → 200
GET
/api/projects/{project_id}/warehouse_saved_queries/{id}/run_history/
Return the recent run history (up to 5 most recent) for this materialized view.
warehouse_saved_queries_run_history_retrieve 2 params → 200
POST
/api/projects/{project_id}/warehouse_saved_queries/resume_schedules/
Resume paused materialization schedules for multiple matviews. Accepts a list of view IDs in the request body: {"viewids": ["id1", "id2", ...]} This endpoint is idempotent - calling it on already run…
warehouse_saved_queries_resume_schedules_create 1 param body → 200

Schemas 10

The contract defines 10 schemas that model the data the API accepts and returns. The most detailed are PatchedDataWarehouseSavedQuery (23 properties), DataWarehouseSavedQuery (23 properties), DataWarehouseSavedQueryMinimal (18 properties), UserBasic (9 properties). Each schema is shown below with its type and property counts.

UserBasic
object
9 properties 4 required
SavedQueryStatusEnum
string
Cancelled - Cancelled Modified - Modified Completed - Completed Failed - Failed Running - Running
BlankEnum
NullEnum
RoleAtOrganizationEnum
string
engineering - Engineering data - Data product - Product Management founder - Founder leadership - Leadership marketing - Marketing sales - Sales / Success othe…
PaginatedDataWarehouseSavedQueryMinimalList
object
4 properties 2 required
DataWarehouseSavedQueryMinimal
object
Lightweight serializer for list views - excludes large query field to reduce memory usage.
18 properties 18 required
DataWarehouseSavedQuery
object
Shared methods for DataWarehouseSavedQuery serializers. This mixin is intended to be used with serializers.ModelSerializer subclasses.
23 properties 16 required
PatchedDataWarehouseSavedQuery
object
Shared methods for DataWarehouseSavedQuery serializers. This mixin is intended to be used with serializers.ModelSerializer subclasses.
23 properties
OriginEnum
string
datawarehouse - Data Warehouse endpoint - Endpoint managedviewset - Managed Viewset

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

posthog-warehouse-saved-queries-api-openapi.yml Raw ↑

Other APIs PostHog publishes across the network.

PostHog Capture API
PostHog Query API
PostHog Persons API
PostHog Feature Flags API
PostHog Experiments API
PostHog Insights API
PostHog Cohorts API
PostHog Annotations API
PostHog actions API
PostHog activity_log API
PostHog activity_logs API
PostHog advanced_activity_logs API
Where this information came from

This is an independent, third-party profile of PostHog warehouse_saved_queries API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.