PostHog API — data_warehouse

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:
        

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