# \[Data Connector 1.0] 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`.