Column in the view whose value is written to the property.

Column in the view whose value matches an account's external_id.

Whether the source syncs; re-enabling it resets the failure count.

UUID of the custom property definition this source feeds. One source per definition.

UUID of the data-warehouse saved query to read from. Required for an account source. For a person or group source it must be a materialized view, and is one of the two binding options. Mutually exclusive with external_data_schema.

Person and group sources only: UUID of the warehouse schema (an imported table) to read from. Mutually exclusive with saved_query; a person or group source sets exactly one.

Account sources only: column in the view whose value is written to the property.

Column whose value identifies the target: an account's external_id for account sources, the person's distinct_id for person sources, or the group key for group sources.

Whether the source syncs. Auto-disabled after repeated failures or a missing view; re-enabling resets the failure count.

Consecutive failed sync runs; the source auto-disables at the cap.

When the most recent sync run finished.

Error summary from the last run, or null if it succeeded.

Person and group sources only: how often the bound table or view runs, in seconds. Null for account sources, or when the schedule is unavailable — including a view whose frequency is set on its data-modeling DAG.

Person and group sources only: approximate time of the next scheduled run (last run + interval). Approximate — drifts if the schedule was paused. Null for account sources, if never run, or when the interval is unavailable.

Table-bound person and group sources only: UUID of the warehouse source owning the schema, so the UI can link to the table. Null for account sources, view-bound sources, or when unavailable.

Person and group sources only: what this source reads, as it is named in HogQL — the imported table, or the view. Null for account sources or when unavailable.

View-bound person and group sources only: the materialized view's name, so the UI can tell a view-backed source from a table-backed one. Null for account and table-bound sources.