The following diagrams visualize the relationships between different tables within the Mercury DWH, and between Mercury and other data marts such as SLXRE2_RG_Ancestry, Sample_QC_Metrics, SLXRE2_Library_Pico_Quant, SLXRE2_Library_Agg_QC and SLXRE2_Sample_Agg_QC and RG_Ancestry.
In the diagrams, PK refers to the Primary Key and UK refers to Unique Keys within the tables.There are 2 schemas in SEQPROD
- MERCURYDW - actual DWH refreshed by Mercury ETL
- MERCURYDWRO - provides Read-Only access to data in MERCURYDW.
PK = Primary Key
UK = Unique Key
Mercurydw table relationships
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| pageId | 613974036 |
|---|
| type | rich |
|---|
| autoSize | 1 |
|---|
| macroId | 9a971060-5943-4a70-bbd8-b4a7f7b4cb52 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 1 |
|---|
| width | 1000 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| consumerKey | Confluence:8792679401 |
|---|
| height | 1000 |
|---|
|
SLXRE2_RG_Ancestry
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| type | rich |
|---|
| autoSize | 0 |
|---|
| macroId | 46dc74c1-451c-4750-913a-fb301f1ef948 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 2 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 1555530379186 |
|---|
| height | 500 |
|---|
|
Sample_QC_Metrics
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| type | rich |
|---|
| autoSize | 0 |
|---|
| macroId | 5cd6f175-dcfd-44dd-9fe3-d73101b4dadc |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 3 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 1555530436970 |
|---|
| height | 500 |
|---|
|
SLXRE2_Library_Pico_Quant
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| type | rich |
|---|
| autoSize | 0 |
|---|
| macroId | b549f413-5d87-4bf3-8a6e-e40cdf3f2e36 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 4 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 1555530456590 |
|---|
| height | 500 |
|---|
|
SLXRE2_Library_Agg_QC & SLXRE2_Sample_Agg_QC
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| type | rich |
|---|
| autoSize | 0 |
|---|
| macroId | 4f91a3b6-90c5-4744-b6c9-a5ff09560c90 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 5 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 1555530491868 |
|---|
| height | 500 |
|---|
|
RG_Ancestry
| Lucidchart |
|---|
| pageCount | 67 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| type | rich |
|---|
| autoSize | 0 |
|---|
| macroId | fd77965b-447c-4f97-a22c-f3fa9aa2108f |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 6 |
|---|
| width | 650350 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 15555305443081557773071892 |
|---|
| height | 450 |
|---|
|
To be included in diagram (RAS 5/8/2019)
...
Array_Process_Flow
| Lucidchart |
|---|
| pageCount | 7 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| pageId | 613974036 |
|---|
| type | rich |
|---|
| autoSize | 1 |
|---|
| macroId | 01cf33bb-8a59-4718-864e-7891aa654def |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 7 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| consumerKey | Confluence:8792679401 |
|---|
| height | 500 |
|---|
|