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 tablesdata.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) anddata.unified_people_values(one row per value of a column that names a person, whichVIA PERSONjoins 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
| source | people |
|---|---|
| github | 48 |
| staff | 61 |
| (unified people) | 74 |
| (conflicts) | 1 |