name: test_id_unification_ex2
keys:
- name: td_client_id
- name: td_global_id
- name: td_ssc_id
- name: email
tables:
- database: test_id_unification_ex2
table: site_aaa
key_columns:
- {column: td_client_id, key: td_client_id}
- {column: td_global_id, key: td_global_id}
- {column: td_ssc_id, key: td_ssc_id}
- database: test_id_unification_ex2
table: site_xxx
key_columns:
- {column: td_ssc_id, key: td_ssc_id}
- {column: td_global_id, key: td_global_id}
- database: test_id_unification_ex2
table: site_yyy
key_columns:
- {column: email, key: email}
- {column: td_ssc_id, key: td_ssc_id}
- database: test_id_unification_ex2
table: site_zzz
key_columns:
- {column: td_client_id, key: td_client_id}
- {column: email, key: email}
canonical_ids:
- name: person_id
merge_by_keys: [email, td_ssc_id, td_client_id, td_global_id]
merge_iterations: 5
master_tables:
- name: master_table_ex2
canonical_id: person_id
attributes:
- name: email
source_columns:
- {table: site_yyy, order: last, order_by: time, priority: 1}
- {table: site_zzz, order: last, order_by: time, priority: 1}
- name: td_ssc_id
array_elements: 5
source_columns:
- {table: site_xxx, order: last, order_by: time, priority: 1}
- {table: site_yyy, order: last, order_by: time, priority: 2}
- name: td_client_id
array_elements: 5
source_columns:
- {table: site_aaa, order: last, order_by: time, priority: 1}
- {table: site_zzz, order: last, order_by: time, priority: 4}
- name: td_global_id
array_elements: 5
source_columns:
- {table: site_aaa, order: last, order_by: time, priority: 1}
- {table: site_xxx, order: last, order_by: time, priority: 2}