Changelog
Updated the data model for
certification_dim and certification_fact. This is a significant update to bring both tables in line with the current state of the certification product. The following fields have been deprecated:
certification_dim:created_at,updated_atcertification_fact:started_at,assessments_completed_at,challenge_started_at,challenge_completed_at,case_study_started_at,case_study_completed_at
The following fields have been added:
certification_fact:registered_at,expired_at,assessments_passed_at,coding_challenge_passed_at,first_exam_started_at,first_exam_completed_at,exam_last_passed_at,case_study_ready_at,first_case_study_submitted_at,last_case_study_submitted_at,is_passed_exams
The following fields have been renamed:
certification_dim:certificate_idtocertification_idcertification_fact:certificate_idtocertification_id
Added new data model for
workspace_visit_fact, containing four fields (visitor_id, workspace_id, visited_at, and nb_seconds). Also added additional fields in workspace_dim (owner_type) and workspace_fact (nb_shares, nb_viewers).Added new data models for
assessments, certification, and workspaces.Last modified 3mo ago