This table captures the streak event of the customers, where the consecutive instances of a task performed by a customer are tracked. These include the current streak count, unique identifiers for event, and streak, and timestamp for the record update.
Fact Table Name: user_streak_fact
User Streak Fact - Entity Relationship Diagram (ERD)
Zoom in the table for more clarity. Click the table title to view its details.
User Streak Fact auto_update_time: bigint current_count: 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 dim_streak_id: bigint dim_streak_status_id: string PK id: bigint year: int Streaks LK streak_id: bigint streak_name: string target-sequence-count: int Streak Status LK id: int value: string 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 Legend
PK Primary Key
LK Linking Key
Streaks Streak Status User Streak Fact
User Streak Fact Table
Column name
Data type
Description
Linked Table auto_update_time
bigint
Date and time when the corresponding record in the streaks table available at the source was last updated. It is in the Unix timestamp format.
_
current_count
bigint
Denotes the streak count (number of times the customer has performed the task in a row).
_
dim_event_date_id
bigint
Start date of the streak.
date
dim_event_time_id
bigint
Start time of the streak.
time
dim_event_user_id
bigint
Identifier for the user associated with the streak. It is an internally assigned value by Capillary for user identification.
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
dim_streak_id
bigint
Identifier linking to a table containing streak information.
streaks
dim_streak_status_id
string
Identifier linking to a table containing streak status information.
streak_status
id
bigint
Unique identifier of the table.
_
year
int
Year of the streak.
_