naftiko: 1.0.0-alpha2 info: label: PostHog API — data_warehouse description: 'PostHog API — data_warehouse. 148 operations. Lead operation: data_warehouse. Self-contained Naftiko capability covering one Posthog business surface.' tags: - Posthog - data_warehouse created: '2026-05-19' modified: '2026-05-19' binds: - namespace: env keys: POSTHOG_API_KEY: POSTHOG_API_KEY capability: consumes: - type: http namespace: posthog-data-warehouse baseUri: '' description: PostHog API — data_warehouse business capability. Self-contained, no shared references. resources: - name: api-environments-environment_id-data_modeling_jobs path: /api/environments/{environment_id}/data_modeling_jobs/ operations: - name: environmentsdatamodelingjobslist method: GET description: List data modeling jobs which are "runs" for our saved queries. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: cursor in: query type: string description: The pagination cursor value. - name: limit in: query type: integer description: Number of results to return per page. - name: saved_query_id in: query type: string - name: api-environments-environment_id-data_modeling_jobs-recent path: /api/environments/{environment_id}/data_modeling_jobs/recent/ operations: - name: environmentsdatamodelingjobsrecentretrieve method: GET description: Get the most recent non-running job for each saved query from the v2 backend. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_modeling_jobs-running path: /api/environments/{environment_id}/data_modeling_jobs/running/ operations: - name: environmentsdatamodelingjobsrunningretrieve method: GET description: Get all currently running jobs from the v2 backend. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_modeling_jobs-id path: /api/environments/{environment_id}/data_modeling_jobs/{id}/ operations: - name: environmentsdatamodelingjobsretrieve method: GET description: List data modeling jobs which are "runs" for our saved queries. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this data modeling job. required: true - name: api-environments-environment_id-data_warehouse-check-database-name path: /api/environments/{environment_id}/data_warehouse/check-database-name/ operations: - name: environmentsdatawarehousecheckdatabasenameretrieve method: GET description: Check if a database name is available. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: name in: query type: string description: Database name to check required: true - name: api-environments-environment_id-data_warehouse-completed_activity path: /api/environments/{environment_id}/data_warehouse/completed_activity/ operations: - name: environmentsdatawarehousecompletedactivityretrieve method: GET description: Returns completed/non-running activities (jobs with status 'Completed'). outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-data_health_issues path: /api/environments/{environment_id}/data_warehouse/data_health_issues/ operations: - name: environmentsdatawarehousedatahealthissuesretrieve method: GET description: Returns failed/disabled data pipeline items for the Pipeline status side panel. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-data_ops_dashboard path: /api/environments/{environment_id}/data_warehouse/data_ops_dashboard/ operations: - name: environmentsdatawarehousedataopsdashboardretrieve method: GET description: Returns the data ops overview dashboard ID for this team, creating it if it doesn't exist yet. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-deprovision path: /api/environments/{environment_id}/data_warehouse/deprovision/ operations: - name: environmentsdatawarehousedeprovisioncreate method: POST description: Start deprovisioning the managed warehouse for this team. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-job_stats path: /api/environments/{environment_id}/data_warehouse/job_stats/ operations: - name: environmentsdatawarehousejobstatsretrieve method: GET description: Returns success and failed job statistics for the last 1, 7, or 30 days. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-property_values path: /api/environments/{environment_id}/data_warehouse/property_values/ operations: - name: environmentsdatawarehousepropertyvaluesretrieve method: GET description: API endpoints for data warehouse aggregate statistics and operations. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-provision path: /api/environments/{environment_id}/data_warehouse/provision/ operations: - name: environmentsdatawarehouseprovisioncreate method: POST description: Start provisioning a managed warehouse for this team. 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-data_warehouse-reset-password path: /api/environments/{environment_id}/data_warehouse/reset-password/ operations: - name: environmentsdatawarehouseresetpasswordcreate method: POST description: Reset the root password for the managed warehouse. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-running_activity path: /api/environments/{environment_id}/data_warehouse/running_activity/ operations: - name: environmentsdatawarehouserunningactivityretrieve method: GET description: Returns currently running activities (jobs with status 'Running'). outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-total_rows_stats path: /api/environments/{environment_id}/data_warehouse/total_rows_stats/ operations: - name: environmentsdatawarehousetotalrowsstatsretrieve method: GET description: Returns aggregated statistics for the data warehouse total rows processed within the current billing period. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-data_warehouse-warehouse_status path: /api/environments/{environment_id}/data_warehouse/warehouse_status/ operations: - name: environmentsdatawarehousewarehousestatusretrieve method: GET description: Get the current provisioning status of the managed warehouse. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-external_data_schemas path: /api/environments/{environment_id}/external_data_schemas/ operations: - name: environmentsexternaldataschemaslist method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: environmentsexternaldataschemascreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: body in: body type: object description: Request body (JSON). required: false - name: api-environments-environment_id-external_data_schemas-id path: /api/environments/{environment_id}/external_data_schemas/{id}/ operations: - name: environmentsexternaldataschemasretrieve method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: environmentsexternaldataschemasupdate method: PUT description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: environmentsexternaldataschemaspartialupdate method: PATCH description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: environmentsexternaldataschemasdestroy method: DELETE description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: api-environments-environment_id-external_data_schemas-id-cancel path: /api/environments/{environment_id}/external_data_schemas/{id}/cancel/ operations: - name: environmentsexternaldataschemascancelcreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-environments-environment_id-external_data_schemas-id-delete_data path: /api/environments/{environment_id}/external_data_schemas/{id}/delete_data/ operations: - name: environmentsexternaldataschemasdeletedatadestroy method: DELETE description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: api-environments-environment_id-external_data_schemas-id-incremental_fields path: /api/environments/{environment_id}/external_data_schemas/{id}/incremental_fields/ operations: - name: environmentsexternaldataschemasincrementalfieldscreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-environments-environment_id-external_data_schemas-id-reload path: /api/environments/{environment_id}/external_data_schemas/{id}/reload/ operations: - name: environmentsexternaldataschemasreloadcreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-environments-environment_id-external_data_schemas-id-resync path: /api/environments/{environment_id}/external_data_schemas/{id}/resync/ operations: - name: environmentsexternaldataschemasresynccreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-environments-environment_id-external_data_sources path: /api/environments/{environment_id}/external_data_sources/ operations: - name: environmentsexternaldatasourceslist method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: environmentsexternaldatasourcescreate method: POST description: Create, Read, Update and Delete External data Sources. 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-external_data_sources-check_cdc_prerequisites path: /api/environments/{environment_id}/external_data_sources/check_cdc_prerequisites/ operations: - name: environmentsexternaldatasourcescheckcdcprerequisitescreate method: POST description: Validate CDC prerequisites against a live Postgres connection. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-external_data_sources-connections path: /api/environments/{environment_id}/external_data_sources/connections/ operations: - name: environmentsexternaldatasourcesconnectionslist method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: api-environments-environment_id-external_data_sources-database_schema path: /api/environments/{environment_id}/external_data_sources/database_schema/ operations: - name: environmentsexternaldatasourcesdatabaseschemacreate method: POST description: Create, Read, Update and Delete External data Sources. 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-external_data_sources-source_prefix path: /api/environments/{environment_id}/external_data_sources/source_prefix/ operations: - name: environmentsexternaldatasourcessourceprefixcreate method: POST description: Create, Read, Update and Delete External data Sources. 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-external_data_sources-wizard path: /api/environments/{environment_id}/external_data_sources/wizard/ operations: - name: environmentsexternaldatasourceswizardretrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-environments-environment_id-external_data_sources-id path: /api/environments/{environment_id}/external_data_sources/{id}/ operations: - name: environmentsexternaldatasourcesretrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: environmentsexternaldatasourcesupdate method: PUT description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: environmentsexternaldatasourcespartialupdate method: PATCH description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: environmentsexternaldatasourcesdestroy method: DELETE description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: api-environments-environment_id-external_data_sources-id-bulk_update_schemas path: /api/environments/{environment_id}/external_data_sources/{id}/bulk_update_schemas/ operations: - name: environmentsexternaldatasourcesbulkupdateschemaspartialupdate method: PATCH description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: body in: body type: object description: Request body (JSON). required: false - name: api-environments-environment_id-external_data_sources-id-create_webhook path: /api/environments/{environment_id}/external_data_sources/{id}/create_webhook/ operations: - name: environmentsexternaldatasourcescreatewebhookcreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-environments-environment_id-external_data_sources-id-delete_webhook path: /api/environments/{environment_id}/external_data_sources/{id}/delete_webhook/ operations: - name: environmentsexternaldatasourcesdeletewebhookcreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-environments-environment_id-external_data_sources-id-jobs path: /api/environments/{environment_id}/external_data_sources/{id}/jobs/ operations: - name: environmentsexternaldatasourcesjobsretrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: api-environments-environment_id-external_data_sources-id-refresh_schemas path: /api/environments/{environment_id}/external_data_sources/{id}/refresh_schemas/ operations: - name: environmentsexternaldatasourcesrefreshschemascreate method: POST description: Fetch current schema/table list from the source and create any new ExternalDataSchema rows (no data sync). outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-environments-environment_id-external_data_sources-id-reload path: /api/environments/{environment_id}/external_data_sources/{id}/reload/ operations: - name: environmentsexternaldatasourcesreloadcreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-environments-environment_id-external_data_sources-id-revenue_analytics_confi path: /api/environments/{environment_id}/external_data_sources/{id}/revenue_analytics_config/ operations: - name: environmentsexternaldatasourcesrevenueanalyticsconfigpartialupdate method: PATCH description: Update the revenue analytics configuration and return the full external data source. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-environments-environment_id-external_data_sources-id-update_webhook_inputs path: /api/environments/{environment_id}/external_data_sources/{id}/update_webhook_inputs/ operations: - name: environmentsexternaldatasourcesupdatewebhookinputscreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-environments-environment_id-external_data_sources-id-webhook_info path: /api/environments/{environment_id}/external_data_sources/{id}/webhook_info/ operations: - name: environmentsexternaldatasourceswebhookinforetrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: api-environments-environment_id-insight_variables path: /api/environments/{environment_id}/insight_variables/ operations: - name: environmentsinsightvariableslist method: GET description: '' 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: environmentsinsightvariablescreate method: POST description: '' 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-insight_variables-id path: /api/environments/{environment_id}/insight_variables/{id}/ operations: - name: environmentsinsightvariablesretrieve method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. required: true - name: environmentsinsightvariablesupdate method: PUT description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: environmentsinsightvariablespartialupdate method: PATCH description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: environmentsinsightvariablesdestroy method: DELETE description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. required: true - 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-environments-environment_id-warehouse_saved_query_folders path: /api/environments/{environment_id}/warehouse_saved_query_folders/ operations: - name: environmentswarehousesavedqueryfolderslist method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. - name: environmentswarehousesavedqueryfolderscreate method: POST description: '' 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_query_folders-id path: /api/environments/{environment_id}/warehouse_saved_query_folders/{id}/ operations: - name: environmentswarehousesavedqueryfoldersretrieve method: GET description: '' 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 folder. required: true - name: environmentswarehousesavedqueryfolderspartialupdate method: PATCH description: '' 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 folder. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: environmentswarehousesavedqueryfoldersdestroy method: DELETE description: '' 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 folder. required: true - name: api-projects-project_id-data_modeling_jobs path: /api/projects/{project_id}/data_modeling_jobs/ operations: - name: datamodelingjobslist method: GET description: List data modeling jobs which are "runs" for our saved queries. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: cursor in: query type: string description: The pagination cursor value. - name: limit in: query type: integer description: Number of results to return per page. - name: saved_query_id in: query type: string - name: api-projects-project_id-data_modeling_jobs-recent path: /api/projects/{project_id}/data_modeling_jobs/recent/ operations: - name: datamodelingjobsrecentretrieve method: GET description: Get the most recent non-running job for each saved query from the v2 backend. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_modeling_jobs-running path: /api/projects/{project_id}/data_modeling_jobs/running/ operations: - name: datamodelingjobsrunningretrieve method: GET description: Get all currently running jobs from the v2 backend. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_modeling_jobs-id path: /api/projects/{project_id}/data_modeling_jobs/{id}/ operations: - name: datamodelingjobsretrieve method: GET description: List data modeling jobs which are "runs" for our saved queries. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this data modeling job. required: true - name: api-projects-project_id-data_warehouse-check-database-name path: /api/projects/{project_id}/data_warehouse/check-database-name/ operations: - name: datawarehousecheckdatabasenameretrieve method: GET description: Check if a database name is available. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: name in: query type: string description: Database name to check required: true - name: api-projects-project_id-data_warehouse-completed_activity path: /api/projects/{project_id}/data_warehouse/completed_activity/ operations: - name: datawarehousecompletedactivityretrieve method: GET description: Returns completed/non-running activities (jobs with status 'Completed'). outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-data_health_issues path: /api/projects/{project_id}/data_warehouse/data_health_issues/ operations: - name: datawarehousedatahealthissuesretrieve method: GET description: Returns failed/disabled data pipeline items for the Pipeline status side panel. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-data_ops_dashboard path: /api/projects/{project_id}/data_warehouse/data_ops_dashboard/ operations: - name: datawarehousedataopsdashboardretrieve method: GET description: Returns the data ops overview dashboard ID for this team, creating it if it doesn't exist yet. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-deprovision path: /api/projects/{project_id}/data_warehouse/deprovision/ operations: - name: datawarehousedeprovisioncreate method: POST description: Start deprovisioning the managed warehouse for this team. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-job_stats path: /api/projects/{project_id}/data_warehouse/job_stats/ operations: - name: datawarehousejobstatsretrieve method: GET description: Returns success and failed job statistics for the last 1, 7, or 30 days. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-property_values path: /api/projects/{project_id}/data_warehouse/property_values/ operations: - name: datawarehousepropertyvaluesretrieve method: GET description: API endpoints for data warehouse aggregate statistics and operations. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-provision path: /api/projects/{project_id}/data_warehouse/provision/ operations: - name: datawarehouseprovisioncreate method: POST description: Start provisioning a managed warehouse for this team. 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-data_warehouse-reset-password path: /api/projects/{project_id}/data_warehouse/reset-password/ operations: - name: datawarehouseresetpasswordcreate method: POST description: Reset the root password for the managed warehouse. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-running_activity path: /api/projects/{project_id}/data_warehouse/running_activity/ operations: - name: datawarehouserunningactivityretrieve method: GET description: Returns currently running activities (jobs with status 'Running'). outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-total_rows_stats path: /api/projects/{project_id}/data_warehouse/total_rows_stats/ operations: - name: datawarehousetotalrowsstatsretrieve method: GET description: Returns aggregated statistics for the data warehouse total rows processed within the current billing period. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-data_warehouse-warehouse_status path: /api/projects/{project_id}/data_warehouse/warehouse_status/ operations: - name: datawarehousewarehousestatusretrieve method: GET description: Get the current provisioning status of the managed warehouse. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-external_data_schemas path: /api/projects/{project_id}/external_data_schemas/ operations: - name: externaldataschemaslist method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: externaldataschemascreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: body in: body type: object description: Request body (JSON). required: false - name: api-projects-project_id-external_data_schemas-id path: /api/projects/{project_id}/external_data_schemas/{id}/ operations: - name: externaldataschemasretrieve method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: externaldataschemasupdate method: PUT description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: externaldataschemaspartialupdate method: PATCH description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: externaldataschemasdestroy method: DELETE description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: api-projects-project_id-external_data_schemas-id-cancel path: /api/projects/{project_id}/external_data_schemas/{id}/cancel/ operations: - name: externaldataschemascancelcreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-projects-project_id-external_data_schemas-id-delete_data path: /api/projects/{project_id}/external_data_schemas/{id}/delete_data/ operations: - name: externaldataschemasdeletedatadestroy method: DELETE description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: api-projects-project_id-external_data_schemas-id-incremental_fields path: /api/projects/{project_id}/external_data_schemas/{id}/incremental_fields/ operations: - name: externaldataschemasincrementalfieldscreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-projects-project_id-external_data_schemas-id-reload path: /api/projects/{project_id}/external_data_schemas/{id}/reload/ operations: - name: externaldataschemasreloadcreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-projects-project_id-external_data_schemas-id-resync path: /api/projects/{project_id}/external_data_schemas/{id}/resync/ operations: - name: externaldataschemasresynccreate method: POST description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data schema. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-projects-project_id-external_data_sources path: /api/projects/{project_id}/external_data_sources/ operations: - name: externaldatasourceslist method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: externaldatasourcescreate method: POST description: Create, Read, Update and Delete External data Sources. 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-external_data_sources-check_cdc_prerequisites path: /api/projects/{project_id}/external_data_sources/check_cdc_prerequisites/ operations: - name: externaldatasourcescheckcdcprerequisitescreate method: POST description: Validate CDC prerequisites against a live Postgres connection. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-external_data_sources-connections path: /api/projects/{project_id}/external_data_sources/connections/ operations: - name: externaldatasourcesconnectionslist method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: api-projects-project_id-external_data_sources-database_schema path: /api/projects/{project_id}/external_data_sources/database_schema/ operations: - name: externaldatasourcesdatabaseschemacreate method: POST description: Create, Read, Update and Delete External data Sources. 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-external_data_sources-source_prefix path: /api/projects/{project_id}/external_data_sources/source_prefix/ operations: - name: externaldatasourcessourceprefixcreate method: POST description: Create, Read, Update and Delete External data Sources. 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-external_data_sources-wizard path: /api/projects/{project_id}/external_data_sources/wizard/ operations: - name: externaldatasourceswizardretrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. - name: api-projects-project_id-external_data_sources-id path: /api/projects/{project_id}/external_data_sources/{id}/ operations: - name: externaldatasourcesretrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: externaldatasourcesupdate method: PUT description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: externaldatasourcespartialupdate method: PATCH description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: externaldatasourcesdestroy method: DELETE description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: api-projects-project_id-external_data_sources-id-bulk_update_schemas path: /api/projects/{project_id}/external_data_sources/{id}/bulk_update_schemas/ operations: - name: externaldatasourcesbulkupdateschemaspartialupdate method: PATCH description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: limit in: query type: integer description: Number of results to return per page. - name: offset in: query type: integer description: The initial index from which to return the results. - name: search in: query type: string description: A search term. - name: body in: body type: object description: Request body (JSON). required: false - name: api-projects-project_id-external_data_sources-id-create_webhook path: /api/projects/{project_id}/external_data_sources/{id}/create_webhook/ operations: - name: externaldatasourcescreatewebhookcreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-projects-project_id-external_data_sources-id-delete_webhook path: /api/projects/{project_id}/external_data_sources/{id}/delete_webhook/ operations: - name: externaldatasourcesdeletewebhookcreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-projects-project_id-external_data_sources-id-jobs path: /api/projects/{project_id}/external_data_sources/{id}/jobs/ operations: - name: externaldatasourcesjobsretrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: api-projects-project_id-external_data_sources-id-refresh_schemas path: /api/projects/{project_id}/external_data_sources/{id}/refresh_schemas/ operations: - name: externaldatasourcesrefreshschemascreate method: POST description: Fetch current schema/table list from the source and create any new ExternalDataSchema rows (no data sync). outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-projects-project_id-external_data_sources-id-reload path: /api/projects/{project_id}/external_data_sources/{id}/reload/ operations: - name: externaldatasourcesreloadcreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-projects-project_id-external_data_sources-id-revenue_analytics_config path: /api/projects/{project_id}/external_data_sources/{id}/revenue_analytics_config/ operations: - name: externaldatasourcesrevenueanalyticsconfigpartialupdate method: PATCH description: Update the revenue analytics configuration and return the full external data source. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: api-projects-project_id-external_data_sources-id-update_webhook_inputs path: /api/projects/{project_id}/external_data_sources/{id}/update_webhook_inputs/ operations: - name: externaldatasourcesupdatewebhookinputscreate method: POST description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: api-projects-project_id-external_data_sources-id-webhook_info path: /api/projects/{project_id}/external_data_sources/{id}/webhook_info/ operations: - name: externaldatasourceswebhookinforetrieve method: GET description: Create, Read, Update and Delete External data Sources. outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this external data source. required: true - name: api-projects-project_id-insight_variables path: /api/projects/{project_id}/insight_variables/ operations: - name: insightvariableslist method: GET description: '' 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: insightvariablescreate method: POST description: '' 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-insight_variables-id path: /api/projects/{project_id}/insight_variables/{id}/ operations: - name: insightvariablesretrieve method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. required: true - name: insightvariablesupdate method: PUT description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. required: true - name: body in: body type: object description: Request body (JSON). required: true - name: insightvariablespartialupdate method: PATCH description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: insightvariablesdestroy method: DELETE description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. inputParameters: - name: id in: path type: string description: A UUID string identifying this insight variable. 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 - name: api-projects-project_id-warehouse_saved_query_folders path: /api/projects/{project_id}/warehouse_saved_query_folders/ operations: - name: warehousesavedqueryfolderslist method: GET description: '' outputRawFormat: json outputParameters: - name: result type: object value: $. - name: warehousesavedqueryfolderscreate method: POST description: '' 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_query_folders-id path: /api/projects/{project_id}/warehouse_saved_query_folders/{id}/ operations: - name: warehousesavedqueryfoldersretrieve method: GET description: '' 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 folder. required: true - name: warehousesavedqueryfolderspartialupdate method: PATCH description: '' 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 folder. required: true - name: body in: body type: object description: Request body (JSON). required: false - name: warehousesavedqueryfoldersdestroy method: DELETE description: '' 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 folder. required: true authentication: type: bearer token: '{{env.POSTHOG_API_KEY}}' exposes: - type: rest namespace: posthog-data-warehouse-rest port: 8080 description: REST adapter for PostHog API — data_warehouse. One Spectral-compliant resource per consumed operation, prefixed with /v1. resources: - path: /v1/api/environments/{environment-id}/data-modeling-jobs name: api-environments-environment-id-data-modeling-jobs description: REST surface for api-environments-environment_id-data_modeling_jobs. operations: - method: GET name: environmentsdatamodelingjobslist description: List data modeling jobs which are "runs" for our saved queries. call: posthog-data-warehouse.environmentsdatamodelingjobslist with: cursor: rest.cursor limit: rest.limit saved_query_id: rest.saved_query_id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-modeling-jobs/recent name: api-environments-environment-id-data-modeling-jobs-recent description: REST surface for api-environments-environment_id-data_modeling_jobs-recent. operations: - method: GET name: environmentsdatamodelingjobsrecentretrieve description: Get the most recent non-running job for each saved query from the v2 backend. call: posthog-data-warehouse.environmentsdatamodelingjobsrecentretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-modeling-jobs/running name: api-environments-environment-id-data-modeling-jobs-running description: REST surface for api-environments-environment_id-data_modeling_jobs-running. operations: - method: GET name: environmentsdatamodelingjobsrunningretrieve description: Get all currently running jobs from the v2 backend. call: posthog-data-warehouse.environmentsdatamodelingjobsrunningretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-modeling-jobs/{id} name: api-environments-environment-id-data-modeling-jobs-id description: REST surface for api-environments-environment_id-data_modeling_jobs-id. operations: - method: GET name: environmentsdatamodelingjobsretrieve description: List data modeling jobs which are "runs" for our saved queries. call: posthog-data-warehouse.environmentsdatamodelingjobsretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/check-database-name name: api-environments-environment-id-data-warehouse-check-database-name description: REST surface for api-environments-environment_id-data_warehouse-check-database-name. operations: - method: GET name: environmentsdatawarehousecheckdatabasenameretrieve description: Check if a database name is available. call: posthog-data-warehouse.environmentsdatawarehousecheckdatabasenameretrieve with: name: rest.name outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/completed-activity name: api-environments-environment-id-data-warehouse-completed-activity description: REST surface for api-environments-environment_id-data_warehouse-completed_activity. operations: - method: GET name: environmentsdatawarehousecompletedactivityretrieve description: Returns completed/non-running activities (jobs with status 'Completed'). call: posthog-data-warehouse.environmentsdatawarehousecompletedactivityretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/data-health-issues name: api-environments-environment-id-data-warehouse-data-health-issues description: REST surface for api-environments-environment_id-data_warehouse-data_health_issues. operations: - method: GET name: environmentsdatawarehousedatahealthissuesretrieve description: Returns failed/disabled data pipeline items for the Pipeline status side panel. call: posthog-data-warehouse.environmentsdatawarehousedatahealthissuesretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/data-ops-dashboard name: api-environments-environment-id-data-warehouse-data-ops-dashboard description: REST surface for api-environments-environment_id-data_warehouse-data_ops_dashboard. operations: - method: GET name: environmentsdatawarehousedataopsdashboardretrieve description: Returns the data ops overview dashboard ID for this team, creating it if it doesn't exist yet. call: posthog-data-warehouse.environmentsdatawarehousedataopsdashboardretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/deprovision name: api-environments-environment-id-data-warehouse-deprovision description: REST surface for api-environments-environment_id-data_warehouse-deprovision. operations: - method: POST name: environmentsdatawarehousedeprovisioncreate description: Start deprovisioning the managed warehouse for this team. call: posthog-data-warehouse.environmentsdatawarehousedeprovisioncreate outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/job-stats name: api-environments-environment-id-data-warehouse-job-stats description: REST surface for api-environments-environment_id-data_warehouse-job_stats. operations: - method: GET name: environmentsdatawarehousejobstatsretrieve description: Returns success and failed job statistics for the last 1, 7, or 30 days. call: posthog-data-warehouse.environmentsdatawarehousejobstatsretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/property-values name: api-environments-environment-id-data-warehouse-property-values description: REST surface for api-environments-environment_id-data_warehouse-property_values. operations: - method: GET name: environmentsdatawarehousepropertyvaluesretrieve description: API endpoints for data warehouse aggregate statistics and operations. call: posthog-data-warehouse.environmentsdatawarehousepropertyvaluesretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/provision name: api-environments-environment-id-data-warehouse-provision description: REST surface for api-environments-environment_id-data_warehouse-provision. operations: - method: POST name: environmentsdatawarehouseprovisioncreate description: Start provisioning a managed warehouse for this team. call: posthog-data-warehouse.environmentsdatawarehouseprovisioncreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/reset-password name: api-environments-environment-id-data-warehouse-reset-password description: REST surface for api-environments-environment_id-data_warehouse-reset-password. operations: - method: POST name: environmentsdatawarehouseresetpasswordcreate description: Reset the root password for the managed warehouse. call: posthog-data-warehouse.environmentsdatawarehouseresetpasswordcreate outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/running-activity name: api-environments-environment-id-data-warehouse-running-activity description: REST surface for api-environments-environment_id-data_warehouse-running_activity. operations: - method: GET name: environmentsdatawarehouserunningactivityretrieve description: Returns currently running activities (jobs with status 'Running'). call: posthog-data-warehouse.environmentsdatawarehouserunningactivityretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/total-rows-stats name: api-environments-environment-id-data-warehouse-total-rows-stats description: REST surface for api-environments-environment_id-data_warehouse-total_rows_stats. operations: - method: GET name: environmentsdatawarehousetotalrowsstatsretrieve description: Returns aggregated statistics for the data warehouse total rows processed within the current billing period. call: posthog-data-warehouse.environmentsdatawarehousetotalrowsstatsretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/data-warehouse/warehouse-status name: api-environments-environment-id-data-warehouse-warehouse-status description: REST surface for api-environments-environment_id-data_warehouse-warehouse_status. operations: - method: GET name: environmentsdatawarehousewarehousestatusretrieve description: Get the current provisioning status of the managed warehouse. call: posthog-data-warehouse.environmentsdatawarehousewarehousestatusretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-schemas name: api-environments-environment-id-external-data-schemas description: REST surface for api-environments-environment_id-external_data_schemas. operations: - method: GET name: environmentsexternaldataschemaslist description: environmentsexternaldataschemaslist call: posthog-data-warehouse.environmentsexternaldataschemaslist with: limit: rest.limit offset: rest.offset search: rest.search outputParameters: - type: object mapping: $. - method: POST name: environmentsexternaldataschemascreate description: environmentsexternaldataschemascreate call: posthog-data-warehouse.environmentsexternaldataschemascreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-schemas/{id} name: api-environments-environment-id-external-data-schemas-id description: REST surface for api-environments-environment_id-external_data_schemas-id. operations: - method: GET name: environmentsexternaldataschemasretrieve description: environmentsexternaldataschemasretrieve call: posthog-data-warehouse.environmentsexternaldataschemasretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: environmentsexternaldataschemasupdate description: environmentsexternaldataschemasupdate call: posthog-data-warehouse.environmentsexternaldataschemasupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: PATCH name: environmentsexternaldataschemaspartialupdate description: environmentsexternaldataschemaspartialupdate call: posthog-data-warehouse.environmentsexternaldataschemaspartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: environmentsexternaldataschemasdestroy description: environmentsexternaldataschemasdestroy call: posthog-data-warehouse.environmentsexternaldataschemasdestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-schemas/{id}/cancel name: api-environments-environment-id-external-data-schemas-id-cancel description: REST surface for api-environments-environment_id-external_data_schemas-id-cancel. operations: - method: POST name: environmentsexternaldataschemascancelcreate description: environmentsexternaldataschemascancelcreate call: posthog-data-warehouse.environmentsexternaldataschemascancelcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-schemas/{id}/delete-data name: api-environments-environment-id-external-data-schemas-id-delete-data description: REST surface for api-environments-environment_id-external_data_schemas-id-delete_data. operations: - method: DELETE name: environmentsexternaldataschemasdeletedatadestroy description: environmentsexternaldataschemasdeletedatadestroy call: posthog-data-warehouse.environmentsexternaldataschemasdeletedatadestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-schemas/{id}/incremental-fields name: api-environments-environment-id-external-data-schemas-id-incremental-fields description: REST surface for api-environments-environment_id-external_data_schemas-id-incremental_fields. operations: - method: POST name: environmentsexternaldataschemasincrementalfieldscreate description: environmentsexternaldataschemasincrementalfieldscreate call: posthog-data-warehouse.environmentsexternaldataschemasincrementalfieldscreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-schemas/{id}/reload name: api-environments-environment-id-external-data-schemas-id-reload description: REST surface for api-environments-environment_id-external_data_schemas-id-reload. operations: - method: POST name: environmentsexternaldataschemasreloadcreate description: environmentsexternaldataschemasreloadcreate call: posthog-data-warehouse.environmentsexternaldataschemasreloadcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-schemas/{id}/resync name: api-environments-environment-id-external-data-schemas-id-resync description: REST surface for api-environments-environment_id-external_data_schemas-id-resync. operations: - method: POST name: environmentsexternaldataschemasresynccreate description: environmentsexternaldataschemasresynccreate call: posthog-data-warehouse.environmentsexternaldataschemasresynccreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources name: api-environments-environment-id-external-data-sources description: REST surface for api-environments-environment_id-external_data_sources. operations: - method: GET name: environmentsexternaldatasourceslist description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourceslist with: limit: rest.limit offset: rest.offset search: rest.search outputParameters: - type: object mapping: $. - method: POST name: environmentsexternaldatasourcescreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcescreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/check-cdc-prerequisites name: api-environments-environment-id-external-data-sources-check-cdc-prerequisites description: REST surface for api-environments-environment_id-external_data_sources-check_cdc_prerequisites. operations: - method: POST name: environmentsexternaldatasourcescheckcdcprerequisitescreate description: Validate CDC prerequisites against a live Postgres connection. call: posthog-data-warehouse.environmentsexternaldatasourcescheckcdcprerequisitescreate outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/connections name: api-environments-environment-id-external-data-sources-connections description: REST surface for api-environments-environment_id-external_data_sources-connections. operations: - method: GET name: environmentsexternaldatasourcesconnectionslist description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesconnectionslist with: limit: rest.limit offset: rest.offset search: rest.search outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/database-schema name: api-environments-environment-id-external-data-sources-database-schema description: REST surface for api-environments-environment_id-external_data_sources-database_schema. operations: - method: POST name: environmentsexternaldatasourcesdatabaseschemacreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesdatabaseschemacreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/source-prefix name: api-environments-environment-id-external-data-sources-source-prefix description: REST surface for api-environments-environment_id-external_data_sources-source_prefix. operations: - method: POST name: environmentsexternaldatasourcessourceprefixcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcessourceprefixcreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/wizard name: api-environments-environment-id-external-data-sources-wizard description: REST surface for api-environments-environment_id-external_data_sources-wizard. operations: - method: GET name: environmentsexternaldatasourceswizardretrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourceswizardretrieve outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id} name: api-environments-environment-id-external-data-sources-id description: REST surface for api-environments-environment_id-external_data_sources-id. operations: - method: GET name: environmentsexternaldatasourcesretrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: environmentsexternaldatasourcesupdate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: PATCH name: environmentsexternaldatasourcespartialupdate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcespartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: environmentsexternaldatasourcesdestroy description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesdestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/bulk-update-schemas name: api-environments-environment-id-external-data-sources-id-bulk-update-schemas description: REST surface for api-environments-environment_id-external_data_sources-id-bulk_update_schemas. operations: - method: PATCH name: environmentsexternaldatasourcesbulkupdateschemaspartialupdate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesbulkupdateschemaspartialupdate with: id: rest.id limit: rest.limit offset: rest.offset search: rest.search body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/create-webhook name: api-environments-environment-id-external-data-sources-id-create-webhook description: REST surface for api-environments-environment_id-external_data_sources-id-create_webhook. operations: - method: POST name: environmentsexternaldatasourcescreatewebhookcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcescreatewebhookcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/delete-webhook name: api-environments-environment-id-external-data-sources-id-delete-webhook description: REST surface for api-environments-environment_id-external_data_sources-id-delete_webhook. operations: - method: POST name: environmentsexternaldatasourcesdeletewebhookcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesdeletewebhookcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/jobs name: api-environments-environment-id-external-data-sources-id-jobs description: REST surface for api-environments-environment_id-external_data_sources-id-jobs. operations: - method: GET name: environmentsexternaldatasourcesjobsretrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesjobsretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/refresh-schemas name: api-environments-environment-id-external-data-sources-id-refresh-schemas description: REST surface for api-environments-environment_id-external_data_sources-id-refresh_schemas. operations: - method: POST name: environmentsexternaldatasourcesrefreshschemascreate description: Fetch current schema/table list from the source and create any new ExternalDataSchema rows (no data sync). call: posthog-data-warehouse.environmentsexternaldatasourcesrefreshschemascreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/reload name: api-environments-environment-id-external-data-sources-id-reload description: REST surface for api-environments-environment_id-external_data_sources-id-reload. operations: - method: POST name: environmentsexternaldatasourcesreloadcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesreloadcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/revenue-analytics-config name: api-environments-environment-id-external-data-sources-id-revenue-analytics-confi description: REST surface for api-environments-environment_id-external_data_sources-id-revenue_analytics_confi. operations: - method: PATCH name: environmentsexternaldatasourcesrevenueanalyticsconfigpartialupdate description: Update the revenue analytics configuration and return the full external data source. call: posthog-data-warehouse.environmentsexternaldatasourcesrevenueanalyticsconfigpartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/update-webhook-inputs name: api-environments-environment-id-external-data-sources-id-update-webhook-inputs description: REST surface for api-environments-environment_id-external_data_sources-id-update_webhook_inputs. operations: - method: POST name: environmentsexternaldatasourcesupdatewebhookinputscreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourcesupdatewebhookinputscreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/external-data-sources/{id}/webhook-info name: api-environments-environment-id-external-data-sources-id-webhook-info description: REST surface for api-environments-environment_id-external_data_sources-id-webhook_info. operations: - method: GET name: environmentsexternaldatasourceswebhookinforetrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.environmentsexternaldatasourceswebhookinforetrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/insight-variables name: api-environments-environment-id-insight-variables description: REST surface for api-environments-environment_id-insight_variables. operations: - method: GET name: environmentsinsightvariableslist description: environmentsinsightvariableslist call: posthog-data-warehouse.environmentsinsightvariableslist with: page: rest.page outputParameters: - type: object mapping: $. - method: POST name: environmentsinsightvariablescreate description: environmentsinsightvariablescreate call: posthog-data-warehouse.environmentsinsightvariablescreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/insight-variables/{id} name: api-environments-environment-id-insight-variables-id description: REST surface for api-environments-environment_id-insight_variables-id. operations: - method: GET name: environmentsinsightvariablesretrieve description: environmentsinsightvariablesretrieve call: posthog-data-warehouse.environmentsinsightvariablesretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: environmentsinsightvariablesupdate description: environmentsinsightvariablesupdate call: posthog-data-warehouse.environmentsinsightvariablesupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: PATCH name: environmentsinsightvariablespartialupdate description: environmentsinsightvariablespartialupdate call: posthog-data-warehouse.environmentsinsightvariablespartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: environmentsinsightvariablesdestroy description: environmentsinsightvariablesdestroy call: posthog-data-warehouse.environmentsinsightvariablesdestroy with: id: rest.id outputParameters: - type: object mapping: $. - 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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.environmentswarehousesavedqueriesretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: environmentswarehousesavedqueriesupdate description: Create, Read, Update and Delete Warehouse Tables. call: posthog-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.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-data-warehouse.environmentswarehousesavedqueriesrunhistoryretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/warehouse-saved-query-folders name: api-environments-environment-id-warehouse-saved-query-folders description: REST surface for api-environments-environment_id-warehouse_saved_query_folders. operations: - method: GET name: environmentswarehousesavedqueryfolderslist description: environmentswarehousesavedqueryfolderslist call: posthog-data-warehouse.environmentswarehousesavedqueryfolderslist outputParameters: - type: object mapping: $. - method: POST name: environmentswarehousesavedqueryfolderscreate description: environmentswarehousesavedqueryfolderscreate call: posthog-data-warehouse.environmentswarehousesavedqueryfolderscreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/environments/{environment-id}/warehouse-saved-query-folders/{id} name: api-environments-environment-id-warehouse-saved-query-folders-id description: REST surface for api-environments-environment_id-warehouse_saved_query_folders-id. operations: - method: GET name: environmentswarehousesavedqueryfoldersretrieve description: environmentswarehousesavedqueryfoldersretrieve call: posthog-data-warehouse.environmentswarehousesavedqueryfoldersretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PATCH name: environmentswarehousesavedqueryfolderspartialupdate description: environmentswarehousesavedqueryfolderspartialupdate call: posthog-data-warehouse.environmentswarehousesavedqueryfolderspartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: environmentswarehousesavedqueryfoldersdestroy description: environmentswarehousesavedqueryfoldersdestroy call: posthog-data-warehouse.environmentswarehousesavedqueryfoldersdestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-modeling-jobs name: api-projects-project-id-data-modeling-jobs description: REST surface for api-projects-project_id-data_modeling_jobs. operations: - method: GET name: datamodelingjobslist description: List data modeling jobs which are "runs" for our saved queries. call: posthog-data-warehouse.datamodelingjobslist with: cursor: rest.cursor limit: rest.limit saved_query_id: rest.saved_query_id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-modeling-jobs/recent name: api-projects-project-id-data-modeling-jobs-recent description: REST surface for api-projects-project_id-data_modeling_jobs-recent. operations: - method: GET name: datamodelingjobsrecentretrieve description: Get the most recent non-running job for each saved query from the v2 backend. call: posthog-data-warehouse.datamodelingjobsrecentretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-modeling-jobs/running name: api-projects-project-id-data-modeling-jobs-running description: REST surface for api-projects-project_id-data_modeling_jobs-running. operations: - method: GET name: datamodelingjobsrunningretrieve description: Get all currently running jobs from the v2 backend. call: posthog-data-warehouse.datamodelingjobsrunningretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-modeling-jobs/{id} name: api-projects-project-id-data-modeling-jobs-id description: REST surface for api-projects-project_id-data_modeling_jobs-id. operations: - method: GET name: datamodelingjobsretrieve description: List data modeling jobs which are "runs" for our saved queries. call: posthog-data-warehouse.datamodelingjobsretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/check-database-name name: api-projects-project-id-data-warehouse-check-database-name description: REST surface for api-projects-project_id-data_warehouse-check-database-name. operations: - method: GET name: datawarehousecheckdatabasenameretrieve description: Check if a database name is available. call: posthog-data-warehouse.datawarehousecheckdatabasenameretrieve with: name: rest.name outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/completed-activity name: api-projects-project-id-data-warehouse-completed-activity description: REST surface for api-projects-project_id-data_warehouse-completed_activity. operations: - method: GET name: datawarehousecompletedactivityretrieve description: Returns completed/non-running activities (jobs with status 'Completed'). call: posthog-data-warehouse.datawarehousecompletedactivityretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/data-health-issues name: api-projects-project-id-data-warehouse-data-health-issues description: REST surface for api-projects-project_id-data_warehouse-data_health_issues. operations: - method: GET name: datawarehousedatahealthissuesretrieve description: Returns failed/disabled data pipeline items for the Pipeline status side panel. call: posthog-data-warehouse.datawarehousedatahealthissuesretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/data-ops-dashboard name: api-projects-project-id-data-warehouse-data-ops-dashboard description: REST surface for api-projects-project_id-data_warehouse-data_ops_dashboard. operations: - method: GET name: datawarehousedataopsdashboardretrieve description: Returns the data ops overview dashboard ID for this team, creating it if it doesn't exist yet. call: posthog-data-warehouse.datawarehousedataopsdashboardretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/deprovision name: api-projects-project-id-data-warehouse-deprovision description: REST surface for api-projects-project_id-data_warehouse-deprovision. operations: - method: POST name: datawarehousedeprovisioncreate description: Start deprovisioning the managed warehouse for this team. call: posthog-data-warehouse.datawarehousedeprovisioncreate outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/job-stats name: api-projects-project-id-data-warehouse-job-stats description: REST surface for api-projects-project_id-data_warehouse-job_stats. operations: - method: GET name: datawarehousejobstatsretrieve description: Returns success and failed job statistics for the last 1, 7, or 30 days. call: posthog-data-warehouse.datawarehousejobstatsretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/property-values name: api-projects-project-id-data-warehouse-property-values description: REST surface for api-projects-project_id-data_warehouse-property_values. operations: - method: GET name: datawarehousepropertyvaluesretrieve description: API endpoints for data warehouse aggregate statistics and operations. call: posthog-data-warehouse.datawarehousepropertyvaluesretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/provision name: api-projects-project-id-data-warehouse-provision description: REST surface for api-projects-project_id-data_warehouse-provision. operations: - method: POST name: datawarehouseprovisioncreate description: Start provisioning a managed warehouse for this team. call: posthog-data-warehouse.datawarehouseprovisioncreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/reset-password name: api-projects-project-id-data-warehouse-reset-password description: REST surface for api-projects-project_id-data_warehouse-reset-password. operations: - method: POST name: datawarehouseresetpasswordcreate description: Reset the root password for the managed warehouse. call: posthog-data-warehouse.datawarehouseresetpasswordcreate outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/running-activity name: api-projects-project-id-data-warehouse-running-activity description: REST surface for api-projects-project_id-data_warehouse-running_activity. operations: - method: GET name: datawarehouserunningactivityretrieve description: Returns currently running activities (jobs with status 'Running'). call: posthog-data-warehouse.datawarehouserunningactivityretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/total-rows-stats name: api-projects-project-id-data-warehouse-total-rows-stats description: REST surface for api-projects-project_id-data_warehouse-total_rows_stats. operations: - method: GET name: datawarehousetotalrowsstatsretrieve description: Returns aggregated statistics for the data warehouse total rows processed within the current billing period. call: posthog-data-warehouse.datawarehousetotalrowsstatsretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/data-warehouse/warehouse-status name: api-projects-project-id-data-warehouse-warehouse-status description: REST surface for api-projects-project_id-data_warehouse-warehouse_status. operations: - method: GET name: datawarehousewarehousestatusretrieve description: Get the current provisioning status of the managed warehouse. call: posthog-data-warehouse.datawarehousewarehousestatusretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-schemas name: api-projects-project-id-external-data-schemas description: REST surface for api-projects-project_id-external_data_schemas. operations: - method: GET name: externaldataschemaslist description: externaldataschemaslist call: posthog-data-warehouse.externaldataschemaslist with: limit: rest.limit offset: rest.offset search: rest.search outputParameters: - type: object mapping: $. - method: POST name: externaldataschemascreate description: externaldataschemascreate call: posthog-data-warehouse.externaldataschemascreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-schemas/{id} name: api-projects-project-id-external-data-schemas-id description: REST surface for api-projects-project_id-external_data_schemas-id. operations: - method: GET name: externaldataschemasretrieve description: externaldataschemasretrieve call: posthog-data-warehouse.externaldataschemasretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: externaldataschemasupdate description: externaldataschemasupdate call: posthog-data-warehouse.externaldataschemasupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: PATCH name: externaldataschemaspartialupdate description: externaldataschemaspartialupdate call: posthog-data-warehouse.externaldataschemaspartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: externaldataschemasdestroy description: externaldataschemasdestroy call: posthog-data-warehouse.externaldataschemasdestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-schemas/{id}/cancel name: api-projects-project-id-external-data-schemas-id-cancel description: REST surface for api-projects-project_id-external_data_schemas-id-cancel. operations: - method: POST name: externaldataschemascancelcreate description: externaldataschemascancelcreate call: posthog-data-warehouse.externaldataschemascancelcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-schemas/{id}/delete-data name: api-projects-project-id-external-data-schemas-id-delete-data description: REST surface for api-projects-project_id-external_data_schemas-id-delete_data. operations: - method: DELETE name: externaldataschemasdeletedatadestroy description: externaldataschemasdeletedatadestroy call: posthog-data-warehouse.externaldataschemasdeletedatadestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-schemas/{id}/incremental-fields name: api-projects-project-id-external-data-schemas-id-incremental-fields description: REST surface for api-projects-project_id-external_data_schemas-id-incremental_fields. operations: - method: POST name: externaldataschemasincrementalfieldscreate description: externaldataschemasincrementalfieldscreate call: posthog-data-warehouse.externaldataschemasincrementalfieldscreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-schemas/{id}/reload name: api-projects-project-id-external-data-schemas-id-reload description: REST surface for api-projects-project_id-external_data_schemas-id-reload. operations: - method: POST name: externaldataschemasreloadcreate description: externaldataschemasreloadcreate call: posthog-data-warehouse.externaldataschemasreloadcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-schemas/{id}/resync name: api-projects-project-id-external-data-schemas-id-resync description: REST surface for api-projects-project_id-external_data_schemas-id-resync. operations: - method: POST name: externaldataschemasresynccreate description: externaldataschemasresynccreate call: posthog-data-warehouse.externaldataschemasresynccreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources name: api-projects-project-id-external-data-sources description: REST surface for api-projects-project_id-external_data_sources. operations: - method: GET name: externaldatasourceslist description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourceslist with: limit: rest.limit offset: rest.offset search: rest.search outputParameters: - type: object mapping: $. - method: POST name: externaldatasourcescreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcescreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/check-cdc-prerequisites name: api-projects-project-id-external-data-sources-check-cdc-prerequisites description: REST surface for api-projects-project_id-external_data_sources-check_cdc_prerequisites. operations: - method: POST name: externaldatasourcescheckcdcprerequisitescreate description: Validate CDC prerequisites against a live Postgres connection. call: posthog-data-warehouse.externaldatasourcescheckcdcprerequisitescreate outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/connections name: api-projects-project-id-external-data-sources-connections description: REST surface for api-projects-project_id-external_data_sources-connections. operations: - method: GET name: externaldatasourcesconnectionslist description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesconnectionslist with: limit: rest.limit offset: rest.offset search: rest.search outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/database-schema name: api-projects-project-id-external-data-sources-database-schema description: REST surface for api-projects-project_id-external_data_sources-database_schema. operations: - method: POST name: externaldatasourcesdatabaseschemacreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesdatabaseschemacreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/source-prefix name: api-projects-project-id-external-data-sources-source-prefix description: REST surface for api-projects-project_id-external_data_sources-source_prefix. operations: - method: POST name: externaldatasourcessourceprefixcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcessourceprefixcreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/wizard name: api-projects-project-id-external-data-sources-wizard description: REST surface for api-projects-project_id-external_data_sources-wizard. operations: - method: GET name: externaldatasourceswizardretrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourceswizardretrieve outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id} name: api-projects-project-id-external-data-sources-id description: REST surface for api-projects-project_id-external_data_sources-id. operations: - method: GET name: externaldatasourcesretrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: externaldatasourcesupdate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: PATCH name: externaldatasourcespartialupdate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcespartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: externaldatasourcesdestroy description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesdestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/bulk-update-schemas name: api-projects-project-id-external-data-sources-id-bulk-update-schemas description: REST surface for api-projects-project_id-external_data_sources-id-bulk_update_schemas. operations: - method: PATCH name: externaldatasourcesbulkupdateschemaspartialupdate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesbulkupdateschemaspartialupdate with: id: rest.id limit: rest.limit offset: rest.offset search: rest.search body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/create-webhook name: api-projects-project-id-external-data-sources-id-create-webhook description: REST surface for api-projects-project_id-external_data_sources-id-create_webhook. operations: - method: POST name: externaldatasourcescreatewebhookcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcescreatewebhookcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/delete-webhook name: api-projects-project-id-external-data-sources-id-delete-webhook description: REST surface for api-projects-project_id-external_data_sources-id-delete_webhook. operations: - method: POST name: externaldatasourcesdeletewebhookcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesdeletewebhookcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/jobs name: api-projects-project-id-external-data-sources-id-jobs description: REST surface for api-projects-project_id-external_data_sources-id-jobs. operations: - method: GET name: externaldatasourcesjobsretrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesjobsretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/refresh-schemas name: api-projects-project-id-external-data-sources-id-refresh-schemas description: REST surface for api-projects-project_id-external_data_sources-id-refresh_schemas. operations: - method: POST name: externaldatasourcesrefreshschemascreate description: Fetch current schema/table list from the source and create any new ExternalDataSchema rows (no data sync). call: posthog-data-warehouse.externaldatasourcesrefreshschemascreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/reload name: api-projects-project-id-external-data-sources-id-reload description: REST surface for api-projects-project_id-external_data_sources-id-reload. operations: - method: POST name: externaldatasourcesreloadcreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesreloadcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/revenue-analytics-config name: api-projects-project-id-external-data-sources-id-revenue-analytics-config description: REST surface for api-projects-project_id-external_data_sources-id-revenue_analytics_config. operations: - method: PATCH name: externaldatasourcesrevenueanalyticsconfigpartialupdate description: Update the revenue analytics configuration and return the full external data source. call: posthog-data-warehouse.externaldatasourcesrevenueanalyticsconfigpartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/update-webhook-inputs name: api-projects-project-id-external-data-sources-id-update-webhook-inputs description: REST surface for api-projects-project_id-external_data_sources-id-update_webhook_inputs. operations: - method: POST name: externaldatasourcesupdatewebhookinputscreate description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourcesupdatewebhookinputscreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/external-data-sources/{id}/webhook-info name: api-projects-project-id-external-data-sources-id-webhook-info description: REST surface for api-projects-project_id-external_data_sources-id-webhook_info. operations: - method: GET name: externaldatasourceswebhookinforetrieve description: Create, Read, Update and Delete External data Sources. call: posthog-data-warehouse.externaldatasourceswebhookinforetrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/insight-variables name: api-projects-project-id-insight-variables description: REST surface for api-projects-project_id-insight_variables. operations: - method: GET name: insightvariableslist description: insightvariableslist call: posthog-data-warehouse.insightvariableslist with: page: rest.page outputParameters: - type: object mapping: $. - method: POST name: insightvariablescreate description: insightvariablescreate call: posthog-data-warehouse.insightvariablescreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/insight-variables/{id} name: api-projects-project-id-insight-variables-id description: REST surface for api-projects-project_id-insight_variables-id. operations: - method: GET name: insightvariablesretrieve description: insightvariablesretrieve call: posthog-data-warehouse.insightvariablesretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: insightvariablesupdate description: insightvariablesupdate call: posthog-data-warehouse.insightvariablesupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: PATCH name: insightvariablespartialupdate description: insightvariablespartialupdate call: posthog-data-warehouse.insightvariablespartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: insightvariablesdestroy description: insightvariablesdestroy call: posthog-data-warehouse.insightvariablesdestroy 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-data-warehouse.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-data-warehouse.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-queries-resume-schedules description: REST surface for api-projects-project_id-warehouse_saved_queries-resume_schedules. operations: - method: POST name: warehousesavedqueriesresumeschedulescreate description: Resume paused materialization schedules for multiple matviews. call: posthog-data-warehouse.warehousesavedqueriesresumeschedulescreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id} name: api-projects-project-id-warehouse-saved-queries-id description: REST surface for api-projects-project_id-warehouse_saved_queries-id. operations: - method: GET name: warehousesavedqueriesretrieve description: Create, Read, Update and Delete Warehouse Tables. call: posthog-data-warehouse.warehousesavedqueriesretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PUT name: warehousesavedqueriesupdate description: Create, Read, Update and Delete Warehouse Tables. call: posthog-data-warehouse.warehousesavedqueriesupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: PATCH name: warehousesavedqueriespartialupdate description: Create, Read, Update and Delete Warehouse Tables. call: posthog-data-warehouse.warehousesavedqueriespartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: warehousesavedqueriesdestroy description: Create, Read, Update and Delete Warehouse Tables. call: posthog-data-warehouse.warehousesavedqueriesdestroy with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/activity name: api-projects-project-id-warehouse-saved-queries-id-activity description: REST surface for api-projects-project_id-warehouse_saved_queries-id-activity. operations: - method: GET name: warehousesavedqueriesactivityretrieve description: Create, Read, Update and Delete Warehouse Tables. call: posthog-data-warehouse.warehousesavedqueriesactivityretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/ancestors name: api-projects-project-id-warehouse-saved-queries-id-ancestors description: REST surface for api-projects-project_id-warehouse_saved_queries-id-ancestors. operations: - method: POST name: warehousesavedqueriesancestorscreate description: Return the ancestors of this saved query. call: posthog-data-warehouse.warehousesavedqueriesancestorscreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/cancel name: api-projects-project-id-warehouse-saved-queries-id-cancel description: REST surface for api-projects-project_id-warehouse_saved_queries-id-cancel. operations: - method: POST name: warehousesavedqueriescancelcreate description: Cancel a running saved query workflow. call: posthog-data-warehouse.warehousesavedqueriescancelcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/dependencies name: api-projects-project-id-warehouse-saved-queries-id-dependencies description: REST surface for api-projects-project_id-warehouse_saved_queries-id-dependencies. operations: - method: GET name: warehousesavedqueriesdependenciesretrieve description: Return the count of immediate upstream and downstream dependencies for this saved query. call: posthog-data-warehouse.warehousesavedqueriesdependenciesretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/descendants name: api-projects-project-id-warehouse-saved-queries-id-descendants description: REST surface for api-projects-project_id-warehouse_saved_queries-id-descendants. operations: - method: POST name: warehousesavedqueriesdescendantscreate description: Return the descendants of this saved query. call: posthog-data-warehouse.warehousesavedqueriesdescendantscreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/materialize name: api-projects-project-id-warehouse-saved-queries-id-materialize description: REST surface for api-projects-project_id-warehouse_saved_queries-id-materialize. operations: - method: POST name: warehousesavedqueriesmaterializecreate description: Enable materialization for this saved query with a 24-hour sync frequency. call: posthog-data-warehouse.warehousesavedqueriesmaterializecreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/revert-materialization name: api-projects-project-id-warehouse-saved-queries-id-revert-materialization description: REST surface for api-projects-project_id-warehouse_saved_queries-id-revert_materialization. operations: - method: POST name: warehousesavedqueriesrevertmaterializationcreate description: Undo materialization, revert back to the original view. call: posthog-data-warehouse.warehousesavedqueriesrevertmaterializationcreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/run name: api-projects-project-id-warehouse-saved-queries-id-run description: REST surface for api-projects-project_id-warehouse_saved_queries-id-run. operations: - method: POST name: warehousesavedqueriesruncreate description: Run this saved query. call: posthog-data-warehouse.warehousesavedqueriesruncreate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-queries/{id}/run-history name: api-projects-project-id-warehouse-saved-queries-id-run-history description: REST surface for api-projects-project_id-warehouse_saved_queries-id-run_history. operations: - method: GET name: warehousesavedqueriesrunhistoryretrieve description: Return the recent run history (up to 5 most recent) for this materialized view. call: posthog-data-warehouse.warehousesavedqueriesrunhistoryretrieve with: id: rest.id outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-query-folders name: api-projects-project-id-warehouse-saved-query-folders description: REST surface for api-projects-project_id-warehouse_saved_query_folders. operations: - method: GET name: warehousesavedqueryfolderslist description: warehousesavedqueryfolderslist call: posthog-data-warehouse.warehousesavedqueryfolderslist outputParameters: - type: object mapping: $. - method: POST name: warehousesavedqueryfolderscreate description: warehousesavedqueryfolderscreate call: posthog-data-warehouse.warehousesavedqueryfolderscreate with: body: rest.body outputParameters: - type: object mapping: $. - path: /v1/api/projects/{project-id}/warehouse-saved-query-folders/{id} name: api-projects-project-id-warehouse-saved-query-folders-id description: REST surface for api-projects-project_id-warehouse_saved_query_folders-id. operations: - method: GET name: warehousesavedqueryfoldersretrieve description: warehousesavedqueryfoldersretrieve call: posthog-data-warehouse.warehousesavedqueryfoldersretrieve with: id: rest.id outputParameters: - type: object mapping: $. - method: PATCH name: warehousesavedqueryfolderspartialupdate description: warehousesavedqueryfolderspartialupdate call: posthog-data-warehouse.warehousesavedqueryfolderspartialupdate with: id: rest.id body: rest.body outputParameters: - type: object mapping: $. - method: DELETE name: warehousesavedqueryfoldersdestroy description: warehousesavedqueryfoldersdestroy call: posthog-data-warehouse.warehousesavedqueryfoldersdestroy with: id: rest.id outputParameters: - type: object mapping: $. - type: mcp namespace: posthog-data-warehouse-mcp port: 9090 transport: http description: MCP adapter for PostHog API — data_warehouse. One tool per consumed operation, routed inline through this capability's consumes block. tools: - name: list-data-modeling-jobs-which description: List data modeling jobs which are "runs" for our saved queries. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatamodelingjobslist with: cursor: tools.cursor limit: tools.limit saved_query_id: tools.saved_query_id outputParameters: - type: object mapping: $. - name: get-most-recent-non-running description: Get the most recent non-running job for each saved query from the v2 backend. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatamodelingjobsrecentretrieve outputParameters: - type: object mapping: $. - name: get-all-currently-running-jobs description: Get all currently running jobs from the v2 backend. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatamodelingjobsrunningretrieve outputParameters: - type: object mapping: $. - name: list-data-modeling-jobs-which-2 description: List data modeling jobs which are "runs" for our saved queries. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatamodelingjobsretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: check-if-database-name-is description: Check if a database name is available. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousecheckdatabasenameretrieve with: name: tools.name outputParameters: - type: object mapping: $. - name: returns-completed-non-running-activities description: Returns completed/non-running activities (jobs with status 'Completed'). hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousecompletedactivityretrieve outputParameters: - type: object mapping: $. - name: returns-failed-disabled-data-pipeline description: Returns failed/disabled data pipeline items for the Pipeline status side panel. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousedatahealthissuesretrieve outputParameters: - type: object mapping: $. - name: returns-data-ops-overview-dashboard description: Returns the data ops overview dashboard ID for this team, creating it if it doesn't exist yet. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousedataopsdashboardretrieve outputParameters: - type: object mapping: $. - name: start-deprovisioning-managed-warehouse-this description: Start deprovisioning the managed warehouse for this team. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsdatawarehousedeprovisioncreate outputParameters: - type: object mapping: $. - name: returns-success-and-failed-job description: Returns success and failed job statistics for the last 1, 7, or 30 days. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousejobstatsretrieve outputParameters: - type: object mapping: $. - name: api-endpoints-data-warehouse-aggregate description: API endpoints for data warehouse aggregate statistics and operations. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousepropertyvaluesretrieve outputParameters: - type: object mapping: $. - name: start-provisioning-managed-warehouse-this description: Start provisioning a managed warehouse for this team. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsdatawarehouseprovisioncreate with: body: tools.body outputParameters: - type: object mapping: $. - name: reset-root-password-managed-warehouse description: Reset the root password for the managed warehouse. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsdatawarehouseresetpasswordcreate outputParameters: - type: object mapping: $. - name: returns-currently-running-activities-jobs description: Returns currently running activities (jobs with status 'Running'). hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehouserunningactivityretrieve outputParameters: - type: object mapping: $. - name: returns-aggregated-statistics-data-warehouse description: Returns aggregated statistics for the data warehouse total rows processed within the current billing period. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousetotalrowsstatsretrieve outputParameters: - type: object mapping: $. - name: get-current-provisioning-status-managed description: Get the current provisioning status of the managed warehouse. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsdatawarehousewarehousestatusretrieve outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemaslist description: environmentsexternaldataschemaslist hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldataschemaslist with: limit: tools.limit offset: tools.offset search: tools.search outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemascreate description: environmentsexternaldataschemascreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldataschemascreate with: body: tools.body outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemasretrieve description: environmentsexternaldataschemasretrieve hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldataschemasretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemasupdate description: environmentsexternaldataschemasupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldataschemasupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemaspartialupdate description: environmentsexternaldataschemaspartialupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldataschemaspartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemasdestroy description: environmentsexternaldataschemasdestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.environmentsexternaldataschemasdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemascancelcreate description: environmentsexternaldataschemascancelcreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldataschemascancelcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemasdeletedatadestroy description: environmentsexternaldataschemasdeletedatadestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.environmentsexternaldataschemasdeletedatadestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemasincrementalfieldscreate description: environmentsexternaldataschemasincrementalfieldscreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldataschemasincrementalfieldscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemasreloadcreate description: environmentsexternaldataschemasreloadcreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldataschemasreloadcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentsexternaldataschemasresynccreate description: environmentsexternaldataschemasresynccreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldataschemasresynccreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourceslist with: limit: tools.limit offset: tools.offset search: tools.search outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-2 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: validate-cdc-prerequisites-against-live description: Validate CDC prerequisites against a live Postgres connection. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcescheckcdcprerequisitescreate outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-3 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcesconnectionslist with: limit: tools.limit offset: tools.offset search: tools.search outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-4 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcesdatabaseschemacreate with: body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-5 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcessourceprefixcreate with: body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-6 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourceswizardretrieve outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-7 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-8 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcesupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-9 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcespartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-10 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcesdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-11 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcesbulkupdateschemaspartialupdate with: id: tools.id limit: tools.limit offset: tools.offset search: tools.search body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-12 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcescreatewebhookcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-13 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcesdeletewebhookcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-14 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcesjobsretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: fetch-current-schema-table-list description: Fetch current schema/table list from the source and create any new ExternalDataSchema rows (no data sync). hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcesrefreshschemascreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-15 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcesreloadcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: update-revenue-analytics-configuration-and description: Update the revenue analytics configuration and return the full external data source. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourcesrevenueanalyticsconfigpartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-16 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsexternaldatasourcesupdatewebhookinputscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-17 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsexternaldatasourceswebhookinforetrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: environmentsinsightvariableslist description: environmentsinsightvariableslist hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsinsightvariableslist with: page: tools.page outputParameters: - type: object mapping: $. - name: environmentsinsightvariablescreate description: environmentsinsightvariablescreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentsinsightvariablescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: environmentsinsightvariablesretrieve description: environmentsinsightvariablesretrieve hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentsinsightvariablesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: environmentsinsightvariablesupdate description: environmentsinsightvariablesupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsinsightvariablesupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentsinsightvariablespartialupdate description: environmentsinsightvariablespartialupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentsinsightvariablespartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentsinsightvariablesdestroy description: environmentsinsightvariablesdestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.environmentsinsightvariablesdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-18 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedquerieslist with: page: tools.page search: tools.search outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-19 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: resume-paused-materialization-schedules-multiple description: Resume paused materialization schedules for multiple matviews. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriesresumeschedulescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-20 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueriesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-21 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueriesupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-22 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueriespartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-23 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueriesdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-24 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueriesactivityretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: return-ancestors-this-saved-query description: Return the ancestors of this saved query. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriesancestorscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: cancel-running-saved-query-workflow description: Cancel a running saved query workflow. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriescancelcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: return-count-immediate-upstream-and description: Return the count of immediate upstream and downstream dependencies for this saved query. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueriesdependenciesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: return-descendants-this-saved-query description: Return the descendants of this saved query. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriesdescendantscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: enable-materialization-this-saved-query description: Enable materialization for this saved query with a 24-hour sync frequency. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriesmaterializecreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: undo-materialization-revert-back-original description: Undo materialization, revert back to the original view. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriesrevertmaterializationcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: run-this-saved-query description: Run this saved query. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueriesruncreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: return-recent-run-history-up description: Return the recent run history (up to 5 most recent) for this materialized view. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueriesrunhistoryretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: environmentswarehousesavedqueryfolderslist description: environmentswarehousesavedqueryfolderslist hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueryfolderslist outputParameters: - type: object mapping: $. - name: environmentswarehousesavedqueryfolderscreate description: environmentswarehousesavedqueryfolderscreate hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.environmentswarehousesavedqueryfolderscreate with: body: tools.body outputParameters: - type: object mapping: $. - name: environmentswarehousesavedqueryfoldersretrieve description: environmentswarehousesavedqueryfoldersretrieve hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueryfoldersretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: environmentswarehousesavedqueryfolderspartialupdate description: environmentswarehousesavedqueryfolderspartialupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueryfolderspartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: environmentswarehousesavedqueryfoldersdestroy description: environmentswarehousesavedqueryfoldersdestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.environmentswarehousesavedqueryfoldersdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: list-data-modeling-jobs-which-3 description: List data modeling jobs which are "runs" for our saved queries. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datamodelingjobslist with: cursor: tools.cursor limit: tools.limit saved_query_id: tools.saved_query_id outputParameters: - type: object mapping: $. - name: get-most-recent-non-running-2 description: Get the most recent non-running job for each saved query from the v2 backend. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datamodelingjobsrecentretrieve outputParameters: - type: object mapping: $. - name: get-all-currently-running-jobs-2 description: Get all currently running jobs from the v2 backend. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datamodelingjobsrunningretrieve outputParameters: - type: object mapping: $. - name: list-data-modeling-jobs-which-4 description: List data modeling jobs which are "runs" for our saved queries. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datamodelingjobsretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: check-if-database-name-is-2 description: Check if a database name is available. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousecheckdatabasenameretrieve with: name: tools.name outputParameters: - type: object mapping: $. - name: returns-completed-non-running-activities-2 description: Returns completed/non-running activities (jobs with status 'Completed'). hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousecompletedactivityretrieve outputParameters: - type: object mapping: $. - name: returns-failed-disabled-data-pipeline-2 description: Returns failed/disabled data pipeline items for the Pipeline status side panel. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousedatahealthissuesretrieve outputParameters: - type: object mapping: $. - name: returns-data-ops-overview-dashboard-2 description: Returns the data ops overview dashboard ID for this team, creating it if it doesn't exist yet. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousedataopsdashboardretrieve outputParameters: - type: object mapping: $. - name: start-deprovisioning-managed-warehouse-this-2 description: Start deprovisioning the managed warehouse for this team. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.datawarehousedeprovisioncreate outputParameters: - type: object mapping: $. - name: returns-success-and-failed-job-2 description: Returns success and failed job statistics for the last 1, 7, or 30 days. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousejobstatsretrieve outputParameters: - type: object mapping: $. - name: api-endpoints-data-warehouse-aggregate-2 description: API endpoints for data warehouse aggregate statistics and operations. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousepropertyvaluesretrieve outputParameters: - type: object mapping: $. - name: start-provisioning-managed-warehouse-this-2 description: Start provisioning a managed warehouse for this team. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.datawarehouseprovisioncreate with: body: tools.body outputParameters: - type: object mapping: $. - name: reset-root-password-managed-warehouse-2 description: Reset the root password for the managed warehouse. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.datawarehouseresetpasswordcreate outputParameters: - type: object mapping: $. - name: returns-currently-running-activities-jobs-2 description: Returns currently running activities (jobs with status 'Running'). hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehouserunningactivityretrieve outputParameters: - type: object mapping: $. - name: returns-aggregated-statistics-data-warehouse-2 description: Returns aggregated statistics for the data warehouse total rows processed within the current billing period. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousetotalrowsstatsretrieve outputParameters: - type: object mapping: $. - name: get-current-provisioning-status-managed-2 description: Get the current provisioning status of the managed warehouse. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.datawarehousewarehousestatusretrieve outputParameters: - type: object mapping: $. - name: externaldataschemaslist description: externaldataschemaslist hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldataschemaslist with: limit: tools.limit offset: tools.offset search: tools.search outputParameters: - type: object mapping: $. - name: externaldataschemascreate description: externaldataschemascreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldataschemascreate with: body: tools.body outputParameters: - type: object mapping: $. - name: externaldataschemasretrieve description: externaldataschemasretrieve hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldataschemasretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: externaldataschemasupdate description: externaldataschemasupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.externaldataschemasupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: externaldataschemaspartialupdate description: externaldataschemaspartialupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.externaldataschemaspartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: externaldataschemasdestroy description: externaldataschemasdestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.externaldataschemasdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: externaldataschemascancelcreate description: externaldataschemascancelcreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldataschemascancelcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: externaldataschemasdeletedatadestroy description: externaldataschemasdeletedatadestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.externaldataschemasdeletedatadestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: externaldataschemasincrementalfieldscreate description: externaldataschemasincrementalfieldscreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldataschemasincrementalfieldscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: externaldataschemasreloadcreate description: externaldataschemasreloadcreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldataschemasreloadcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: externaldataschemasresynccreate description: externaldataschemasresynccreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldataschemasresynccreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-25 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourceslist with: limit: tools.limit offset: tools.offset search: tools.search outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-26 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: validate-cdc-prerequisites-against-live-2 description: Validate CDC prerequisites against a live Postgres connection. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcescheckcdcprerequisitescreate outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-27 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourcesconnectionslist with: limit: tools.limit offset: tools.offset search: tools.search outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-28 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcesdatabaseschemacreate with: body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-29 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcessourceprefixcreate with: body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-30 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourceswizardretrieve outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-31 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourcesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-32 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourcesupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-33 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourcespartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-34 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.externaldatasourcesdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-35 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourcesbulkupdateschemaspartialupdate with: id: tools.id limit: tools.limit offset: tools.offset search: tools.search body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-36 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcescreatewebhookcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-37 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcesdeletewebhookcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-38 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourcesjobsretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: fetch-current-schema-table-list-2 description: Fetch current schema/table list from the source and create any new ExternalDataSchema rows (no data sync). hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcesrefreshschemascreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-39 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcesreloadcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: update-revenue-analytics-configuration-and-2 description: Update the revenue analytics configuration and return the full external data source. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourcesrevenueanalyticsconfigpartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-40 description: Create, Read, Update and Delete External data Sources. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.externaldatasourcesupdatewebhookinputscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-41 description: Create, Read, Update and Delete External data Sources. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.externaldatasourceswebhookinforetrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: insightvariableslist description: insightvariableslist hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.insightvariableslist with: page: tools.page outputParameters: - type: object mapping: $. - name: insightvariablescreate description: insightvariablescreate hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.insightvariablescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: insightvariablesretrieve description: insightvariablesretrieve hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.insightvariablesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: insightvariablesupdate description: insightvariablesupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.insightvariablesupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: insightvariablespartialupdate description: insightvariablespartialupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.insightvariablespartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: insightvariablesdestroy description: insightvariablesdestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.insightvariablesdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-42 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedquerieslist with: page: tools.page search: tools.search outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-43 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: resume-paused-materialization-schedules-multiple-2 description: Resume paused materialization schedules for multiple matviews. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriesresumeschedulescreate with: body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-44 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueriesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-45 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueriesupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-46 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueriespartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-47 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.warehousesavedqueriesdestroy with: id: tools.id outputParameters: - type: object mapping: $. - name: create-read-update-and-delete-48 description: Create, Read, Update and Delete Warehouse Tables. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueriesactivityretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: return-ancestors-this-saved-query-2 description: Return the ancestors of this saved query. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriesancestorscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: cancel-running-saved-query-workflow-2 description: Cancel a running saved query workflow. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriescancelcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: return-count-immediate-upstream-and-2 description: Return the count of immediate upstream and downstream dependencies for this saved query. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueriesdependenciesretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: return-descendants-this-saved-query-2 description: Return the descendants of this saved query. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriesdescendantscreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: enable-materialization-this-saved-query-2 description: Enable materialization for this saved query with a 24-hour sync frequency. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriesmaterializecreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: undo-materialization-revert-back-original-2 description: Undo materialization, revert back to the original view. hints: readOnly: false destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriesrevertmaterializationcreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: run-this-saved-query-2 description: Run this saved query. hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueriesruncreate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: return-recent-run-history-up-2 description: Return the recent run history (up to 5 most recent) for this materialized view. hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueriesrunhistoryretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: warehousesavedqueryfolderslist description: warehousesavedqueryfolderslist hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueryfolderslist outputParameters: - type: object mapping: $. - name: warehousesavedqueryfolderscreate description: warehousesavedqueryfolderscreate hints: readOnly: true destructive: false idempotent: false call: posthog-data-warehouse.warehousesavedqueryfolderscreate with: body: tools.body outputParameters: - type: object mapping: $. - name: warehousesavedqueryfoldersretrieve description: warehousesavedqueryfoldersretrieve hints: readOnly: true destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueryfoldersretrieve with: id: tools.id outputParameters: - type: object mapping: $. - name: warehousesavedqueryfolderspartialupdate description: warehousesavedqueryfolderspartialupdate hints: readOnly: false destructive: false idempotent: true call: posthog-data-warehouse.warehousesavedqueryfolderspartialupdate with: id: tools.id body: tools.body outputParameters: - type: object mapping: $. - name: warehousesavedqueryfoldersdestroy description: warehousesavedqueryfoldersdestroy hints: readOnly: false destructive: true idempotent: true call: posthog-data-warehouse.warehousesavedqueryfoldersdestroy with: id: tools.id outputParameters: - type: object mapping: $.