Content 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. Log in to REPORTING@SEQPROD on SQL Navigator and run the following query:

   Code Block
   language sql
   SELECT DISTINCT s.bsp_collaborator_sample_id, s.collaborator_participant_id, s.aggregation_project, s.last_aggregation_date, s.external_sample_id, s.pdo_name, s.pdo_sample_id, s.sample_delivery_status, s.sample_is_billed FROM cognos.pdo_star5 s WHERE s.bsp_collaborator_sample_id IN ('oldcollabSMID1','oldcollabSMID2')

   
   

2. If records are returned, then either there are supposed to be some samples remaining (this is less frequent) or datamarts need refreshing.
3. Before refreshing PDO STAR, first check to see if SLXRE_READGROUP_METADATA is updated (section 1.2 below).
4. If readgroup metadata is updated, then the PDO STAR datamart needs a refresh (see sections 2.1-2.3 below). Note the PDO_NAME of any records returned. Before refreshing PDO STAR, first check to see if SLXRE_READGROUP_METADATA is updated.

1.2. Check whether SLXRE_READGROUP_METADATA is updated

...

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

...