Skip to main content

REFRESH PEOPLE

Commands › People · Admins only, through sercha_define or a tenant file

Reads the people every connector and every CREATE PEOPLE declares, resolves them by their keys and rewrites the people tables.

Syntax​

REFRESH PEOPLE

Usage notes​

  • Rewrites data.people_<source> for each source and the shared tables data.unified_people (one row per person), data.unified_people_accounts (one row per source person, with its unified id), data.unified_people_keys (one row per key of a source person) and data.unified_people_values (one row per value of a column that names a person, which VIA PERSON joins through).
  • Returns one row per source with its people count, then (unified people), (conflicts) and a (not read) ... row for each table that could not be read.
  • A refresh also runs in the background after a sync of a source that names people. Run this after a new or changed declaration.

Examples​

REFRESH PEOPLE
sourcepeople
github48
staff61
(unified people)74
(conflicts)1

See also​

CREATE PEOPLE · DROP PEOPLE