Page Comparison

In some occasions, the analytics team may need to take specific actions to check or update changes in the datamarts. Examples in which this may happen may include the following:

...

1.  Check for metrics in DB with the following queries:

   Code Block
   language sql
   SELECT * FROM analytics.bsp_sample WHERE collaborator_sample_id IN 'oldcollabSMID1, oldcollabSMID2' ; SELECT * FROM metrics.basecalling_analysis ba WHERE ba.flowcell_barcode IN ('HTH3KBBXX') AND ba.metrics_type IN ('Indexed', 'Unindexed') ; SELECT * FROM metrics.picard_analysis ba WHERE ba.flowcell_barcode IN ('HTH3KBBXX') AND ba.metrics_type IN ('Indexed', 'Unindexed') ; --Understand when flowcells were updated in Analytics DM SELECT * FROM cognos.slxre_rghqs_targets t WHERE t.flowcell_barcode = --'HTH3KBBXX' ;

   
   

1.4. Check aggregations

...

...

1. Rerun the PDO_STAR query above. This refresh is immediate, so you can run the query right away.
2. If it returns nothing, the DM is all set.
3. If it still returns records, ensure that that is unexpected behavior and try the refresh again. (occasionally, there are other samples that need to remain with the "old" IDs, as is usually the case in sample swaps)
   1. If it still returns unexpected records, talk with Nasko.

2.4. Refreshing the ReadgroupMetadata DM in SEQPROD Database

...

Requesting sample metadata changes

Tiger3 ETL Shell Commands (refreshes, etc.)