PostHog

PostHog Data Warehouse API

The data_warehouse API from PostHog — 110 operation(s) for data_warehouse.

GitHub OpenAPI

Operations 148

GET /api/environments/{environment_id}/data_modeling_jobs/ Environments data modeling jobs list #
GET /api/environments/{environment_id}/data_modeling_jobs/{id}/ Environments data modeling jobs retrieve #
GET /api/environments/{environment_id}/data_modeling_jobs/recent/ Environments data modeling jobs recent retrieve #
GET /api/environments/{environment_id}/data_modeling_jobs/running/ Environments data modeling jobs running retrieve #
GET /api/environments/{environment_id}/data_warehouse/check-database-name/ Environments data warehouse check database name retrieve #
GET /api/environments/{environment_id}/data_warehouse/completed_activity/ Environments data warehouse completed activity retrieve #
GET /api/environments/{environment_id}/data_warehouse/data_health_issues/ Environments data warehouse data health issues retrieve #
GET /api/environments/{environment_id}/data_warehouse/data_ops_dashboard/ Environments data warehouse data ops dashboard retrieve #
POST /api/environments/{environment_id}/data_warehouse/deprovision/ Environments data warehouse deprovision create #
GET /api/environments/{environment_id}/data_warehouse/job_stats/ Environments data warehouse job stats retrieve #
GET /api/environments/{environment_id}/data_warehouse/property_values/ Environments data warehouse property values retrieve #
POST /api/environments/{environment_id}/data_warehouse/provision/ Environments data warehouse provision create #
POST /api/environments/{environment_id}/data_warehouse/reset-password/ Environments data warehouse reset password create #
GET /api/environments/{environment_id}/data_warehouse/running_activity/ Environments data warehouse running activity retrieve #
GET /api/environments/{environment_id}/data_warehouse/total_rows_stats/ Environments data warehouse total rows stats retrieve #
GET /api/environments/{environment_id}/data_warehouse/warehouse_status/ Environments data warehouse warehouse status retrieve #
GET /api/environments/{environment_id}/external_data_schemas/ Environments external data schemas list #
POST /api/environments/{environment_id}/external_data_schemas/ Environments external data schemas create #
GET /api/environments/{environment_id}/external_data_schemas/{id}/ Environments external data schemas retrieve #
PUT /api/environments/{environment_id}/external_data_schemas/{id}/ Environments external data schemas update #
PATCH /api/environments/{environment_id}/external_data_schemas/{id}/ Environments external data schemas partial update #
DELETE /api/environments/{environment_id}/external_data_schemas/{id}/ Environments external data schemas destroy #
POST /api/environments/{environment_id}/external_data_schemas/{id}/cancel/ Environments external data schemas cancel create #
DELETE /api/environments/{environment_id}/external_data_schemas/{id}/delete_data/ Environments external data schemas delete data destroy #
POST /api/environments/{environment_id}/external_data_schemas/{id}/incremental_fields/ Environments external data schemas incremental fields create #
POST /api/environments/{environment_id}/external_data_schemas/{id}/reload/ Environments external data schemas reload create #
POST /api/environments/{environment_id}/external_data_schemas/{id}/resync/ Environments external data schemas resync create #
GET /api/environments/{environment_id}/external_data_sources/ Environments external data sources list #
POST /api/environments/{environment_id}/external_data_sources/ Environments external data sources create #
GET /api/environments/{environment_id}/external_data_sources/{id}/ Environments external data sources retrieve #
PUT /api/environments/{environment_id}/external_data_sources/{id}/ Environments external data sources update #
PATCH /api/environments/{environment_id}/external_data_sources/{id}/ Environments external data sources partial update #
DELETE /api/environments/{environment_id}/external_data_sources/{id}/ Environments external data sources destroy #
PATCH /api/environments/{environment_id}/external_data_sources/{id}/bulk_update_schemas/ Environments external data sources bulk update schemas partial update #
POST /api/environments/{environment_id}/external_data_sources/{id}/create_webhook/ Environments external data sources create webhook create #
POST /api/environments/{environment_id}/external_data_sources/{id}/delete_webhook/ Environments external data sources delete webhook create #
GET /api/environments/{environment_id}/external_data_sources/{id}/jobs/ Environments external data sources jobs retrieve #
POST /api/environments/{environment_id}/external_data_sources/{id}/refresh_schemas/ Environments external data sources refresh schemas create #
POST /api/environments/{environment_id}/external_data_sources/{id}/reload/ Environments external data sources reload create #
PATCH /api/environments/{environment_id}/external_data_sources/{id}/revenue_analytics_config/ Environments external data sources revenue analytics config partial update #
POST /api/environments/{environment_id}/external_data_sources/{id}/update_webhook_inputs/ Environments external data sources update webhook inputs create #
GET /api/environments/{environment_id}/external_data_sources/{id}/webhook_info/ Environments external data sources webhook info retrieve #
POST /api/environments/{environment_id}/external_data_sources/check_cdc_prerequisites/ Environments external data sources check cdc prerequisites create #
GET /api/environments/{environment_id}/external_data_sources/connections/ Environments external data sources connections list #
POST /api/environments/{environment_id}/external_data_sources/database_schema/ Environments external data sources database schema create #
POST /api/environments/{environment_id}/external_data_sources/source_prefix/ Environments external data sources source prefix create #
GET /api/environments/{environment_id}/external_data_sources/wizard/ Environments external data sources wizard retrieve #
GET /api/environments/{environment_id}/insight_variables/ Environments insight variables list #
POST /api/environments/{environment_id}/insight_variables/ Environments insight variables create #
GET /api/environments/{environment_id}/insight_variables/{id}/ Environments insight variables retrieve #
PUT /api/environments/{environment_id}/insight_variables/{id}/ Environments insight variables update #
PATCH /api/environments/{environment_id}/insight_variables/{id}/ Environments insight variables partial update #
DELETE /api/environments/{environment_id}/insight_variables/{id}/ Environments insight variables destroy #
GET /api/environments/{environment_id}/warehouse_saved_queries/ Environments warehouse saved queries list #
POST /api/environments/{environment_id}/warehouse_saved_queries/ Environments warehouse saved queries create #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/ Environments warehouse saved queries retrieve #
PUT /api/environments/{environment_id}/warehouse_saved_queries/{id}/ Environments warehouse saved queries update #
PATCH /api/environments/{environment_id}/warehouse_saved_queries/{id}/ Environments warehouse saved queries partial update #
DELETE /api/environments/{environment_id}/warehouse_saved_queries/{id}/ Environments warehouse saved queries destroy #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/activity/ Environments warehouse saved queries activity retrieve #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/ancestors/ Environments warehouse saved queries ancestors create #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/cancel/ Environments warehouse saved queries cancel create #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/dependencies/ Environments warehouse saved queries dependencies retrieve #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/descendants/ Environments warehouse saved queries descendants create #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/materialize/ Environments warehouse saved queries materialize create #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/revert_materialization/ Environments warehouse saved queries revert materialization create #
POST /api/environments/{environment_id}/warehouse_saved_queries/{id}/run/ Environments warehouse saved queries run create #
GET /api/environments/{environment_id}/warehouse_saved_queries/{id}/run_history/ Environments warehouse saved queries run history retrieve #
POST /api/environments/{environment_id}/warehouse_saved_queries/resume_schedules/ Environments warehouse saved queries resume schedules create #
GET /api/environments/{environment_id}/warehouse_saved_query_folders/ Environments warehouse saved query folders list #
POST /api/environments/{environment_id}/warehouse_saved_query_folders/ Environments warehouse saved query folders create #
GET /api/environments/{environment_id}/warehouse_saved_query_folders/{id}/ Environments warehouse saved query folders retrieve #
PATCH /api/environments/{environment_id}/warehouse_saved_query_folders/{id}/ Environments warehouse saved query folders partial update #
DELETE /api/environments/{environment_id}/warehouse_saved_query_folders/{id}/ Environments warehouse saved query folders destroy #
GET /api/projects/{project_id}/data_modeling_jobs/ Data modeling jobs list #
GET /api/projects/{project_id}/data_modeling_jobs/{id}/ Data modeling jobs retrieve #
GET /api/projects/{project_id}/data_modeling_jobs/recent/ Data modeling jobs recent retrieve #
GET /api/projects/{project_id}/data_modeling_jobs/running/ Data modeling jobs running retrieve #
GET /api/projects/{project_id}/data_warehouse/check-database-name/ Data warehouse check database name retrieve #
GET /api/projects/{project_id}/data_warehouse/completed_activity/ Data warehouse completed activity retrieve #
GET /api/projects/{project_id}/data_warehouse/data_health_issues/ Data warehouse data health issues retrieve #
GET /api/projects/{project_id}/data_warehouse/data_ops_dashboard/ Data warehouse data ops dashboard retrieve #
POST /api/projects/{project_id}/data_warehouse/deprovision/ Data warehouse deprovision create #
GET /api/projects/{project_id}/data_warehouse/job_stats/ Data warehouse job stats retrieve #
GET /api/projects/{project_id}/data_warehouse/property_values/ Data warehouse property values retrieve #
POST /api/projects/{project_id}/data_warehouse/provision/ Data warehouse provision create #
POST /api/projects/{project_id}/data_warehouse/reset-password/ Data warehouse reset password create #
GET /api/projects/{project_id}/data_warehouse/running_activity/ Data warehouse running activity retrieve #
GET /api/projects/{project_id}/data_warehouse/total_rows_stats/ Data warehouse total rows stats retrieve #
GET /api/projects/{project_id}/data_warehouse/warehouse_status/ Data warehouse warehouse status retrieve #
GET /api/projects/{project_id}/external_data_schemas/ External data schemas list #
POST /api/projects/{project_id}/external_data_schemas/ External data schemas create #
GET /api/projects/{project_id}/external_data_schemas/{id}/ External data schemas retrieve #
PUT /api/projects/{project_id}/external_data_schemas/{id}/ External data schemas update #
PATCH /api/projects/{project_id}/external_data_schemas/{id}/ External data schemas partial update #
DELETE /api/projects/{project_id}/external_data_schemas/{id}/ External data schemas destroy #
POST /api/projects/{project_id}/external_data_schemas/{id}/cancel/ External data schemas cancel create #
DELETE /api/projects/{project_id}/external_data_schemas/{id}/delete_data/ External data schemas delete data destroy #
POST /api/projects/{project_id}/external_data_schemas/{id}/incremental_fields/ External data schemas incremental fields create #
POST /api/projects/{project_id}/external_data_schemas/{id}/reload/ External data schemas reload create #
POST /api/projects/{project_id}/external_data_schemas/{id}/resync/ External data schemas resync create #
GET /api/projects/{project_id}/external_data_sources/ External data sources list #
POST /api/projects/{project_id}/external_data_sources/ External data sources create #
GET /api/projects/{project_id}/external_data_sources/{id}/ External data sources retrieve #
PUT /api/projects/{project_id}/external_data_sources/{id}/ External data sources update #
PATCH /api/projects/{project_id}/external_data_sources/{id}/ External data sources partial update #
DELETE /api/projects/{project_id}/external_data_sources/{id}/ External data sources destroy #
PATCH /api/projects/{project_id}/external_data_sources/{id}/bulk_update_schemas/ External data sources bulk update schemas partial update #
POST /api/projects/{project_id}/external_data_sources/{id}/create_webhook/ External data sources create webhook create #
POST /api/projects/{project_id}/external_data_sources/{id}/delete_webhook/ External data sources delete webhook create #
GET /api/projects/{project_id}/external_data_sources/{id}/jobs/ External data sources jobs retrieve #
POST /api/projects/{project_id}/external_data_sources/{id}/refresh_schemas/ External data sources refresh schemas create #
POST /api/projects/{project_id}/external_data_sources/{id}/reload/ External data sources reload create #
PATCH /api/projects/{project_id}/external_data_sources/{id}/revenue_analytics_config/ External data sources revenue analytics config partial update #
POST /api/projects/{project_id}/external_data_sources/{id}/update_webhook_inputs/ External data sources update webhook inputs create #
GET /api/projects/{project_id}/external_data_sources/{id}/webhook_info/ External data sources webhook info retrieve #
POST /api/projects/{project_id}/external_data_sources/check_cdc_prerequisites/ External data sources check cdc prerequisites create #
GET /api/projects/{project_id}/external_data_sources/connections/ External data sources connections list #
POST /api/projects/{project_id}/external_data_sources/database_schema/ External data sources database schema create #
POST /api/projects/{project_id}/external_data_sources/source_prefix/ External data sources source prefix create #
GET /api/projects/{project_id}/external_data_sources/wizard/ External data sources wizard retrieve #
GET /api/projects/{project_id}/insight_variables/ Insight variables list #
POST /api/projects/{project_id}/insight_variables/ Insight variables create #
GET /api/projects/{project_id}/insight_variables/{id}/ Insight variables retrieve #
PUT /api/projects/{project_id}/insight_variables/{id}/ Insight variables update #
PATCH /api/projects/{project_id}/insight_variables/{id}/ Insight variables partial update #
DELETE /api/projects/{project_id}/insight_variables/{id}/ Insight variables destroy #
GET /api/projects/{project_id}/warehouse_saved_queries/ Warehouse saved queries list #
POST /api/projects/{project_id}/warehouse_saved_queries/ Warehouse saved queries create #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/ Warehouse saved queries retrieve #
PUT /api/projects/{project_id}/warehouse_saved_queries/{id}/ Warehouse saved queries update #
PATCH /api/projects/{project_id}/warehouse_saved_queries/{id}/ Warehouse saved queries partial update #
DELETE /api/projects/{project_id}/warehouse_saved_queries/{id}/ Warehouse saved queries destroy #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/activity/ Warehouse saved queries activity retrieve #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/ancestors/ Warehouse saved queries ancestors create #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/cancel/ Warehouse saved queries cancel create #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/dependencies/ Warehouse saved queries dependencies retrieve #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/descendants/ Warehouse saved queries descendants create #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/materialize/ Warehouse saved queries materialize create #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/revert_materialization/ Warehouse saved queries revert materialization create #
POST /api/projects/{project_id}/warehouse_saved_queries/{id}/run/ Warehouse saved queries run create #
GET /api/projects/{project_id}/warehouse_saved_queries/{id}/run_history/ Warehouse saved queries run history retrieve #
POST /api/projects/{project_id}/warehouse_saved_queries/resume_schedules/ Warehouse saved queries resume schedules create #
GET /api/projects/{project_id}/warehouse_saved_query_folders/ Warehouse saved query folders list #
POST /api/projects/{project_id}/warehouse_saved_query_folders/ Warehouse saved query folders create #
GET /api/projects/{project_id}/warehouse_saved_query_folders/{id}/ Warehouse saved query folders retrieve #
PATCH /api/projects/{project_id}/warehouse_saved_query_folders/{id}/ Warehouse saved query folders partial update #
DELETE /api/projects/{project_id}/warehouse_saved_query_folders/{id}/ Warehouse saved query folders destroy #

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-data-warehouse-api-openapi.yml
⚙
AsyncAPI
https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/asyncapi/posthog-webhooks-asyncapi.yml

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-data-warehouse-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-data-warehouse-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: PostHog Data Warehouse API
  version: 1.0.0
  description: ''
tags:


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