data_catalog

Trust marks on warehouse tables and views. Reads exclude soft-deleted targets.

post/api/projects/{project_id}/data_catalog/certifications/

Request

  • Base URL: https://us.posthog.com
  • URL: https://us.posthog.com/api/projects/{project_id}/data_catalog/certifications/
  • Auth: HTTP bearer

Path parameters

project_idstring required

Project ID of the project you're trying to access. To find the ID of the project, make a call to /api/projects/.

Request body

table_idstring uuid

Warehouse table id to certify (XOR the other targets).

saved_query_idstring uuid

Warehouse view (saved query) id to certify.

table_namestring

Queryable HogQL table name; 409 with candidates if ambiguous.

view_namestring

Queryable HogQL view name; 409 with candidates if ambiguous.

notesstring

Why this mark exists.

proposed_status'certified' | 'deprecated'
  • certified - certified
  • deprecated - deprecated

Response

idstring uuid required
tablestring uuid nullable required

The warehouse table this mark applies to (XOR saved_query).

saved_querystring uuid nullable required

The warehouse view this mark applies to (XOR table).

target_typestring required

Whether the marked target is a 'table' or a 'view'.

target_namestring required

Queryable HogQL name of the marked table or view.

statusstring required

proposed, certified (prefer this source), or deprecated (avoid this source).

proposed_statusstring required

The mark the proposal asks for: 'certified' (trust this source) or 'deprecated' (avoid this source). Informational once the mark is settled.

notesstring

Why this mark exists, e.g. 'canonical MRR source'.

certified_atstring date-time nullable required
created_byinteger nullable required
created_atstring date-time required

Changes

No recorded changes to this operation across all 1 revision of this API.