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:
- Consent withdrawal
- Participants may voluntarily request to withdraw their participation from specific ongoing research studies or other projects. Regulations indicate that any existing metadata must be updated to reflect such withdrawal request. These changes may not be readily available until the right steps are followed to update the metadata on the the withdrawal, which requires following the correct process to update our datamarts.
- Fingerprinting and gender related changes
- Requests for fingerprinting reanalyses and gender related changes may occur for several reasons such as missing FP assays, sample swaps, and collaborator requests. These changes may not refresh automatically in the datamarts for which refresh pushes may be necessary.
The main steps a user may need to follow in these occasions includes include checking metadata changes and pushing datamart refreshes. The processes explained below are meant to help the user take step-by-step actions if and when required. A user may not need to take the steps in all processes.
...
- Rerun the PDO_STAR query above. This refresh is immediate, so you can run the query right away.
- If it returns nothing, the DM is all set.
- 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)
- If it still returns unexpected records, talk with Nasko.
2.5. ReadgroupMetadata DM Refresh in SEQPROD Database
...