Changelog

2023-05-26

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_at

• certification_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_id to certification_id

• certification_fact: certificate_id to certification_id

2023-05-16

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

2022-02-24

Added new data models for assessments, certification, and workspaces.