Client Registry¶
This is the authoritative registry of all XO-Data client identifiers. Every system in the platform derives client naming from these two canonical forms.
Identifier Formats¶
Each client has two identifier formats:
- Domain (long form): Used in S3 paths, DAG names, roster tables. Always a single lowercase word with no spaces or special characters.
- Code (short form): A 3-letter uppercase abbreviation used in database names and shorthand references.
Registry¶
| Display Name | Domain | Code | Database | Status |
|---|---|---|---|---|
| Warby Parker | warbyparker |
WBP |
WBP_DB |
Active |
| Conde Nast | condenast |
CND |
CND_DB |
Active |
| Hello Fresh | hellofresh |
HFS |
HFS_DB |
Planned |
| Morgan & Morgan | morganandmorgan |
MMN |
MMN_DB |
Planned |
| Flare | flare |
FLR |
FLR_DB |
Planned |
| Blackacre | blackacre |
BKA |
BKA_DB |
Planned |
| Sonrava | sonrava |
SNR |
SNR_DB |
Planned |
| Match | match |
MCH |
MCH_DB |
Planned |
| JCrew | jcrew |
JCR |
JCR_DB |
Planned |
| IONOS | ionos |
ION |
ION_DB |
Planned |
| NBA | nba |
NBA |
NBA_DB |
Planned |
Where Each Identifier Is Used¶
| System | Identifier | Case | Example |
|---|---|---|---|
| S3 paths | Domain | lowercase | s3://xo-stage/warbyparker/conversations/... |
| Airflow DAG names | Domain | lowercase | warbyparker_daily_operations_dag |
| Snowflake databases | Code | UPPERCASE | WBP_DB |
| Snowflake roster tables | Domain | UPPERCASE | CORE_DB.SILVER.ROSTER_WARBYPARKER |
| YAML config filenames | Domain | lowercase | warbyparker-gladly-conversations.yaml |
| dbt project vars | Code | lowercase | client_code: wbp |
Rules for Adding New Clients¶
- Code: Pick a 3-letter abbreviation from the client's initials or name. Check the registry above for collisions.
- Domain: Lowercase version of the display name with no spaces, hyphens, ampersands, or special characters (e.g., "Morgan & Morgan" becomes
morganandmorgan). - Database:
{CODE}_DB(e.g.,FLR_DB). - Add the entry to this registry before creating any infrastructure.
Historical Notes¶
- Keller Postman was renamed to Blackacre (
BKA). The codeKLPis retired and should not be reused.
Known Inconsistencies¶
Conde Nast code mismatch
Some older dbt project files use CN instead of CND for Conde Nast. The canonical code is CND. Occurrences of CN should be migrated to CND when those files are next modified.