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:
...
| Tip | ||||
|---|---|---|---|---|
| ||||
Review Tiger3 ETL Shell for more details on this section |
| Info |
|---|
PDO STAR automatically refreshes samples that are not billed every two hours, and does a full refresh of 1-year data on Friday mornings at 2:55 am. If metadata change requests are for orders that are not billed or are less than a year old, a manual push may not be necessary. However, step 2.3 below should be followed regardless to check whether the metadata changes were made in PDO STAR. |
2.1. Option 1 for Manual Refresh in PDO STAR using a query (using PDO_NAMEs)
...
- 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.4. Refreshing the ReadgroupMetadata DM in SEQPROD Database
| Tip | ||||
|---|---|---|---|---|
| ||||
Review Analytics ETL Framework for more details on this section |
...