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. _
