ONIX workflow Step 2 - Linking Metrics

Step 2 of the ONIX workflow takes the metrics fetched through various telescopes, then aggregates and joins them to the book records in the publisher’s ONIX feed.

../../_images/onix_workflow_2.png

Book Product Schema

The output is the book_product table, containing one row per unique book, with a nested month field, which groups all the metrics relating to that book for each calendar month.

Link to Query