This page aims to show how the data gets into and how it's stored on BigQuery. It's a conceptual representation of the data objects, the associations between them, and the rules. It will start from a high level perspective until getting to a more detailed view.
Summary
Dataset Schema
Datasets
Access_rights
Supports data to allow user's access to some categorized data.
Datasets ARCHIVED
These dataset are now archived. Their data is already available on raw_data_ELN_EWHA.
ARCHIVED_raw_data_ELN_corp
ARCHIVED_raw_data_ELN_spechem
ELNHistoricalData
Historical pré-ELN data (MUSigma data). There are no updates but the data is used in some calculations for other datasets.
Raw_data (Ewha)
Raw data for Ewha cycler machines.
raw_data_BOLLATE
Raw data for Bollate cycler machines.
raw_data_ELN_EWHA
Old ELN templates raw data for Ewha. The data updates are meant to stop, but the data should be kept.
raw_data_ELN_BOLLATE
Old ELN templates raw data for Bollate. The data updates are meant to stop, but the data should be kept.
raw_data_ELN_BOL_EWHA
Dataset for the ELN standard template for Bollate and Ewha.
technical_data
All stage or intermediate tables. This a technical database used for integration and computation. Usually the data here will come from the "raw data" datasets and they will flow to a enriched dataset.
enriched_data
Cleaned, consolidated and integrated data.
enriched_data_user
Report purposes dataset. The objects are created and maintained by the Tableau developers.