PostHog

PostHog warehouse_saved_queries API

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

GitHub OpenAPI

Operations 32

GET /api/environments/{environment_id}/warehouse_saved_queries/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/ #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/ #
PUT /api/environments/{environment_id}/warehouse_saved_queries/{id}/ #
PATCH /api/environments/{environment_id}/warehouse_saved_queries/{id}/ #
DELETE /api/environments/{environment_id}/warehouse_saved_queries/{id}/ #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/activity/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/ancestors/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/cancel/ #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/dependencies/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/descendants/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/materialize/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/revert_materialization/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/run/ #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/run_history/ #
POST /api/environments/{environment_id}/warehouse_saved_queries/resume_schedules/ #
GET /api/projects/{project_id}/warehouse_saved_queries/ #
POST /api/projects/{project_id}/warehouse_saved_queries/ #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/ #
PUT /api/projects/{project_id}/warehouse_saved_queries/{id}/ #
PATCH /api/projects/{project_id}/warehouse_saved_queries/{id}/ #
DELETE /api/projects/{project_id}/warehouse_saved_queries/{id}/ #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/activity/ #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/ancestors/ #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/cancel/ #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/dependencies/ #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/descendants/ #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/materialize/ #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/revert_materialization/ #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/run/ #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/run_history/ #
POST /api/projects/{project_id}/warehouse_saved_queries/resume_schedules/ #

Documentation

📖
Documentation
https://posthog.com/docs/api
📖
GettingStarted
https://posthog.com/docs/api
📖
Authentication
https://posthog.com/docs/api#authentication

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/openapi/posthog-warehouse-saved-queries-api-openapi.yml
⚙
AsyncAPI
https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/asyncapi/posthog-webhooks-asyncapi.yml

Other Resources

🔗
GraphQL
https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/graphql/posthog-graphql.md

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/posthog-warehouse-saved-queries-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

posthog-warehouse-saved-queries-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: PostHog actions Warehouse Saved Queries API
  version: 1.0.0
  description: ''
servers:
- url: https://app.posthog.com/api
  description: Base URL declared by the provider in apis.yml (roadmap#122).
tags:
- name: warehouse_saved_queries
paths:
  /api/environments/{environment_id}/warehouse_saved_queries/:
    get:
      operationId: environments_warehouse_saved_queries_list
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - name: page
        required: false
        in: query
        description: A page number within the paginated result set.
        schema:
          type: integer
      - name: search
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedDataWarehouseSavedQueryMinimalList'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    post:
      operationId: environments_warehouse_saved_queries_create
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '201':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/:
    get:
      operationId: environments_warehouse_saved_queries_retrieve
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    put:
      operationId: environments_warehouse_saved_queries_update
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    patch:
      operationId: environments_warehouse_saved_queries_partial_update
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PatchedDataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/PatchedDataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/PatchedDataWarehouseSavedQuery'
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    delete:
      operationId: environments_warehouse_saved_queries_destroy
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '204':
          description: No response body
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/activity/:
    get:
      operationId: environments_warehouse_saved_queries_activity_retrieve
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - activity_log:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/ancestors/:
    post:
      operationId: environments_warehouse_saved_queries_ancestors_create
      description: '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 only

        ancestors beyond the root), we return an empty list.'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/cancel/:
    post:
      operationId: environments_warehouse_saved_queries_cancel_create
      description: Cancel a running saved query workflow.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/dependencies/:
    get:
      operationId: environments_warehouse_saved_queries_dependencies_retrieve
      description: Return the count of immediate upstream and downstream dependencies for this saved query.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/descendants/:
    post:
      operationId: environments_warehouse_saved_queries_descendants_create
      description: '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. points to only

        descendants further than a leaf), we return an empty list.'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/materialize/:
    post:
      operationId: environments_warehouse_saved_queries_materialize_create
      description: Enable materialization for this saved query with a 24-hour sync frequency.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/revert_materialization/:
    post:
      operationId: environments_warehouse_saved_queries_revert_materialization_create
      description: 'Undo materialization, revert back to the original view.

        (i.e. delete the materialized table and the schedule)'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/run/:
    post:
      operationId: environments_warehouse_saved_queries_run_create
      description: Run this saved query.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/{id}/run_history/:
    get:
      operationId: environments_warehouse_saved_queries_run_history_retrieve
      description: Return the recent run history (up to 5 most recent) for this materialized view.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/warehouse_saved_queries/resume_schedules/:
    post:
      operationId: environments_warehouse_saved_queries_resume_schedules_create
      description: 'Resume paused materialization schedules for multiple matviews.


        Accepts a list of view IDs in the request body: {"view_ids": ["id1", "id2", ...]}

        This endpoint is idempotent - calling it on already running or non-existent schedules is safe.'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/:
    get:
      operationId: warehouse_saved_queries_list
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - name: page
        required: false
        in: query
        description: A page number within the paginated result set.
        schema:
          type: integer
      - $ref: '#/components/parameters/ProjectIdPath'
      - name: search
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedDataWarehouseSavedQueryMinimalList'
          description: ''
      x-explicit-tags:
      - data_warehouse
    post:
      operationId: warehouse_saved_queries_create
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '201':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/:
    get:
      operationId: warehouse_saved_queries_retrieve
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
    put:
      operationId: warehouse_saved_queries_update
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
    patch:
      operationId: warehouse_saved_queries_partial_update
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PatchedDataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/PatchedDataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/PatchedDataWarehouseSavedQuery'
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
    delete:
      operationId: warehouse_saved_queries_destroy
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '204':
          description: No response body
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/activity/:
    get:
      operationId: warehouse_saved_queries_activity_retrieve
      description: Create, Read, Update and Delete Warehouse Tables.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      security:
      - PersonalAPIKeyAuth:
        - activity_log:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/ancestors/:
    post:
      operationId: warehouse_saved_queries_ancestors_create
      description: '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 only

        ancestors beyond the root), we return an empty list.'
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/cancel/:
    post:
      operationId: warehouse_saved_queries_cancel_create
      description: Cancel a running saved query workflow.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/dependencies/:
    get:
      operationId: warehouse_saved_queries_dependencies_retrieve
      description: Return the count of immediate upstream and downstream dependencies for this saved query.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/descendants/:
    post:
      operationId: warehouse_saved_queries_descendants_create
      description: '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. points to only

        descendants further than a leaf), we return an empty list.'
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/materialize/:
    post:
      operationId: warehouse_saved_queries_materialize_create
      description: Enable materialization for this saved query with a 24-hour sync frequency.
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/revert_materialization/:
    post:
      operationId: warehouse_saved_queries_revert_materialization_create
      description: 'Undo materialization, revert back to the original view.

        (i.e. delete the materialized table and the schedule)'
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this data warehouse saved query.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - warehouse_saved_queries
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/DataWarehouseSavedQuery'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - warehouse_view:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataWarehouseSavedQuery'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/warehouse_saved_queries/{id}/run/:
    post:
      operationId: warehouse_saved_queries_run_create
      description: Ru

# --- truncated at 32 KB (52 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/openapi/posthog-warehouse-saved-queries-api-openapi.yml