This table captures the information of the referrers. A referrer is a customer who refers other customers to transact with the brand. This fact table captures all the information surrounding the referrer, such as the referrer identifier, date and time of the referral, campaign associated with the referral, and the token associated with the referral campaign.
Databricks Table Name: referrers
Referrers Fact - Entity Relationship Diagram (ERD)
Referrers auto_update_time: bigint dim_campaign_id: bigint dim_event_date_id: bigint dim_event_time_id: bigint dim_event_user_id: bigint dim_latest_updated_date_id: bigint dim_latest_updated_time_id: bigint PK referrer_id: bigint token: string year: int Referrers Date LK date_id: int day_of_month: int week_of_year: int month: string year: int quarter: string week_number: int week_start_date: string week_end_date: string day_of_week: string month_no: int month_no_of_year: int month_of_year: string day_of_week_no: int quarter_no: int yearly_quarter_no: int date: string Date Time LK time_id: bigint time: string hour_of_day: int minute_of_day: int day_shift: string day_shift_no: int hour_range: string Time users auto_update_merged_customer: bigint auto_update_loyalty: bigint fraud_status: string test_control_bucket: string is_merged_customer: string subscription_status_email_bulk: string first_name: string slab_name: string subscription_status_wechat_bulk: string email: string last_name: string merged_user_id: bigint LK user_id: bigint subscription_status_wechat_trans: string subscription_status_sms_bulk: string ndnc_status: string subscription_status_email_trans: string test_control_status: string auto_update_fraud_user: bigint is_inactive: string source: string slab_number: int auto_update_users: bigint registered_till_id: bigint auto_update_customer_enrollment: bigint slab_expiry_date: string customer_external_id: string subscription_status_sms_trans: string mobile: string loyalty_type: string auto_update_ndnc_status: bigint Users Campaigns is_recurring: string campaign_end_date: string is_migrated: string auto_update_campaign: bigint LK campaign_id: bigint campaign_type: string roi_type: string campaign_start_date: string name: string Campaigns Legend
PK Primary Key
LK Linking Key
Zoom in the table for more clarity. Click the table title to view its details.
Referrers Fact Table
Column Name
Data Type
Description
Linked Table auto_update_time
bigint
Date and time when the corresponding table available at the source was last updated. It is in the Unix timestamp format.
_
dim_campaign_id
bigint
Identifier for the campaign associated with the referral action.
campaign
dim_event_date_id
bigint
Date when the referral action occurred.
date
dim_event_time_id
bigint
Time when the referral action occurred.
time
dim_event_user_id
bigint
Identifier for the customer associated with the referral action.
users
dim_latest_updated_date_id
bigint
Date when the data corresponding to this event/row is changed in the source table.
date
dim_latest_updated_time_id
bigint
Time when the data corresponding to this event/row is changed in the source table.
time
referrer_id
bigint
Unique identifier for the referrer (the customer who referred another customer). It is the primary key for this table.
_
token
string
Unique token of the referral campaign.
_
year
int
Year of the referral.
_
