Data model with the tables used by all laboratories.
Summary
BigQuery Presentation Tables
All the tables available on BigQuery have a "delta" table with a similar schema. The delta tables work as staging for the the final tables. Those tables are used for applying some data quality and deduplication.
They also avoid some data loss as the final tables are update just if the delta table has data on it.
Following below, a final table list by subject:
Application Lab
Synthesis Lab
Analysis Lab
Other Datasets
Tableau Presentation Tables
The data model used on Tableau is available on: https://drive.google.com/file/d/1zC7hq1lJQ4OOTa-rVaDYOFEW1Q4De5LH/view
