/
Refresh Datamarts with runEtl tool

Refresh Datamarts with runEtl tool

  1. Go to https://analytics.broadinstitute.org

  2. Click on “Log in” and use your Broad login (if it doesn’t let you in, contact analytics so Nasko @Atanas Mihalev can whitelist your username)

  3. Click on “Run ETL”

  4. Select the ETL agent you want to run

  5. Paste the proper input values and Run it. When the pages refreshes, check the message.

ETL

Example format

Tips

ETL

Example format

Tips

PdoStar by (PDO,Sample)

PDO-12345,SM-123DE

PDO-12345,SM-123AB

PDO-56789, SM-ABCD3

SM-ABCD4

SM-ABCD5

One sample per line.

Extra spaces are fine.

PDO must precede a sample or list of samples.

PDO & sample can be separated by comma or space(s).

PdoStar by (CollaboratorSample)

HAP1aa

Penny1

CHOP 1266a

 

One sample per line.

Spaces will be inferred as part of the sampleID.

No commas allowed.

 

Rghqs

(Flowcell)

HHYT7BLXX
HHYT7BMXX

One FC per line.

Extra spaces are fine.

No commas allowed.

If there are “exception” errors/failures, copy the TIGERETL_RUNID (and/or screenshot the message) to help Nasko troubleshoot.

 

 

 

Development of tool: RPT-5744, RPT-5781, RPT-5791

 

Related content

Tiger3 ETL Shell Commands (refreshes, etc.)
Tiger3 ETL Shell Commands (refreshes, etc.)
More like this
Refreshing Analytics data marts after Mercury DWH stalled
Refreshing Analytics data marts after Mercury DWH stalled
More like this
DRAGEN metrics naming convention in Analytics tools
DRAGEN metrics naming convention in Analytics tools
Read with this
Checking & refreshing metadata changes
Checking & refreshing metadata changes
More like this
Analytics Group Meeting Notes
Analytics Group Meeting Notes
Read with this
Refresh Analytics DWH when Product Names change
Refresh Analytics DWH when Product Names change
More like this