warehouse_column_statistics

Read per-column data statistics (null fraction, min/max, row count) for warehouse tables.

Statistics are computed automatically after a sync and surfaced to the AI agent so it can write better queries. They are system-owned and read-only here. List can be filtered to one table with ?table_id=<uuid>.

get/api/projects/{project_id}/warehouse_column_statistics/{id}/

Request

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

Path parameters

idstring uuid required

A UUID string identifying this warehouse column statistics.

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/.

Response

idstring uuid required
tablestring uuid required

ID of the data warehouse table this column belongs to.

column_namestring required

Name of the column these statistics describe.

column_typestring required

ClickHouse type the statistics were computed against (e.g. Int64, DateTime64).

row_countinteger required

Total number of rows in the table when these statistics were computed.

null_countinteger required

Number of NULL values in this column, or null if the Delta log carried no count.

null_fractionnumber double required

Fraction of values that are NULL (null_count / row_count), between 0 and 1.

min_valuestring required

Minimum value in the column, as a string. Null when unavailable. For string columns this may be truncated by the underlying Delta statistics, so treat string bounds as approximate.

max_valuestring required

Maximum value in the column, as a string. Null when unavailable (see min_value).

has_min_maxboolean required

Whether the Delta log carried min/max statistics for this column (false for some nested/binary types).

computed_atstring date-time required

When these statistics were last computed.

computed_for_delta_versioninteger required

Delta table version the statistics were computed against.

stats_basisstring required

How the statistics were produced. Currently always 'delta_log'.

created_atstring date-time required
updated_atstring date-time nullable required

Changes

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