Customer Merge Log Fact Table

This table captures the details of customer account merges within the system. It includes information about the accounts involved, the reason for the merge, and the date and time details of various events related to the merge process.

Databricks Table Name: customer_merge_log

Customer Merge Log - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.

Customer Merge Logauto_update_time: bigintdetails: stringdim_event_date_id: bigintdim_event_time_id: bigintdim_event_user_id: bigintdim_latest_updated_date_id: bigintdim_latest_updated_time_id: bigintdim_merged_by_admin_id: bigintdim_merged_by_zone_till_id: bigintdim_victim_user_id: bigintPKmerge_event_id: bigintmerge_reason: stringvictim_external_id: stringvictim_mobile: stringyear: intAdmin Usersis_active: intis_deleted: intmiddle_name: stringfirst_name: stringemail: stringLKid: bigintlast_name: stringdateLKdate_id: intday_of_month: intweek_of_year: intmonth: stringyear: intquarter: stringweek_number: intweek_start_date: stringweek_end_date: stringday_of_week: stringmonth_no: intmonth_no_of_year: intmonth_of_year: stringday_of_week_no: intquarter_no: intyearly_quarter_no: intdate: stringDateTimeLKtime_id: biginttime: stringhour_of_day: intminute_of_day: intday_shift: stringday_shift_no: inthour_range: stringTimeusersauto_update_merged_customer: bigintauto_update_loyalty: bigintfraud_status: stringtest_control_bucket: stringis_merged_customer: stringsubscription_status_email_bulk: stringfirst_name: stringslab_name: stringsubscription_status_wechat_bulk: stringemail: stringlast_name: stringmerged_user_id: bigintLKuser_id: bigintsubscription_status_wechat_trans: stringsubscription_status_sms_bulk: stringndnc_status: stringsubscription_status_email_trans: stringtest_control_status: stringauto_update_fraud_user: bigintis_inactive: stringsource: stringslab_number: intauto_update_users: bigintregistered_till_id: bigintauto_update_customer_enrollment: bigintslab_expiry_date: stringcustomer_external_id: stringsubscription_status_sms_trans: stringmobile: stringloyalty_type: stringauto_update_ndnc_status: bigintUsersZone_tillsstore_country: stringexternal_id_1: stringstore: stringauto_update_till_parent: bigintarea: stringstore_name: stringstore_city: stringstore_state: stringtill: stringauto_update_till_store_relation: bigintis_ffc_enabled: stringLKtill_id: biginttype: stringtill_description: stringauto_update_till: bigintstore_channel: stringexternal_id: stringis_billable: stringstore_id: bigintis_active: stringauto_update_store: bigintstore_description: stringlatitude: stringtimezone: stringexternal_id_2: stringtill_name: stringzone_name: stringZone TillsCustomer Merge LogAdmin Users

Legend

PK   Primary Key

LK   Linking Key

Fact Table
Dimension Table

Customer Merge Log Fact Table

Column Name

Data Type

Description

Linked Table

Availability for Export in the

Customer Merge Event

Log Template

auto_update_time

bigint

Date and time when the corresponding record in the communications table available at the source was last updated. It is in the Unix timestamp format.

_

Yes; Measure Name: Auto Update Time

details

string

Details about the merge process.

_

Yes; Measure Name: Details

dim_event_date_id

bigint

Date when the customer profile was merged.

date

Yes; Dimension Name: Date > Date

dim_event_time_id

bigint

Time when the customer profile was merged.

time

Yes; Dimension Name: Time > Time Id

dim_event_user_id

bigint

Current user id of the customer whose account was merged.

users

Yes; Dimension Name: User > User Id

dim_latest_updated_date_id

bigint

Date when the data corresponding to this event/row is changed in the source table.

date

Yes; Dimension Name: Latest Updated Date > Date

dim_latest_updated_time_id

bigint

Time when the data corresponding to this event/row is changed in the source table.

time

Yes; Dimension Name: Latest Updated Time > Time Id

dim_merged_by_admin_id

bigint

Identifier for the admin user who performed the merge.

admin_users

Yes; Dimension Name: Merge By Admin User > Id

dim_merged_by_zone_till_id

bigint

Identifier for the store (till) where the customer profile was merged.

zone till

Yes; Dimension Name: Merge By Till > Till Id

dim_victim_user_id

bigint

Identifier for the user with which the customer profile was merged.

users

Yes; Dimension Name: Victim User > User Id

merge_event_id

bigint

Unique identifier for the merge event. It is the primary key of this table.

_

Yes; Measure Name: Merge Event Id

merge_reason

string

The reason provided for merging the accounts.

_

Yes; Measure Name: Merge Reason

victim_external_id

string

External id of customer for which the customer profile has been merged.

_

Yes; Measure Name: Victim External Id

victim_mobile

string

Mobile number of the customer for which the customer profile has been merged.

_

Yes; Measure Name: Victim Mobile

year

int

Year when the merge occurred.

_

Yes; Dimension Name: Year