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.
Image Added
Following below, a final table list by subject:
Application Lab
| Embedded Google Drive File |
|---|
| docid | 1SdQ2Q6nY7q5TY1igeLJpDx6v1ixmIYkpiMZ6eaEpAc0 |
|---|
| selectedonly | true |
|---|
| height | 400px |
|---|
|
Synthesis Lab
| Embedded Google Drive File |
|---|
| docid | 1Ta5mKOMo59BzDkUVNHAV5ZCUmF8dWbY3vgJANt90nFM |
|---|
| selectedonly | true |
|---|
| height | 400px |
|---|
|
Analysis Lab
| Embedded Google Drive File |
|---|
| docid | 1XC5dK5SzJe0N8cTrWjDSDNToyfw6lABNvz1eGohqncM |
|---|
| selectedonly | true |
|---|
| height | 300px |
|---|
|
Other Datasets
| Embedded Google Drive File |
|---|
| docid | 1xYZXcNAjjd1QJEgpU3Vy64pP7kUOcau5Ui32ZNrdnZY |
|---|
| selectedonly | true |
|---|
| height | 150px |
|---|
|
Tableau Presentation Tables
The data model used on Tableau is available on: https://drive.google.com/file/d/1zC7hq1lJQ4OOTa-rVaDYOFEW1Q4De5LH/view
...
