ONIX workflow Step 3 - Exporting to Looker Studio
Step three of the ONIX workflow is to export the book_product table to a sequence of flattened data export tables. The data in these tables is not materially different to the book product table, just organised in a way better suited for dashboards in Looker Studio.
Since these are date-sharded tables, their names will be updated each time the workflow is run. When using Google’s Looker (previously Data Studio), it is preferable for us to use a static naming scheme. For this reason, after creating the (sharded) export and quality analysis tables, we also create/update a view for table. These views have a static name. By referencing the view, we can keep the Looker dashboards up-to-date without manual intervention.
Book Metric
Book Product List Schema
This table is a list of each Book Product. It is primarily used for drop-down fields, or where a list of all the books independent of metrics is desired.
Book Product Metrics Schema
This table contains metrics, organised by month, that are linked to each book. The country, city, institution, events and referrals expand on this to provided further useful breakdowns of metrics.
Book Product Year Metrics Schema
This table contains metrics, organised by published year and month, that are linked to each book.
Book Product Event Metrics Schema
This table contains metrics, organised by month and crossref event type, that are linked to each book.
Book Product Metrics City Schema
This table contains metrics, organised by month and city of measured usage, that are linked to each book.
Book Product Metrics Country Schema
This table contains metrics, organised by month and country of measured usage, that are linked to each book.
Book Product Metrics Events Schema
This table contains metrics, organised by month and crossref event type, that are linked to each book.
Institution List Schema
This table is a list of each unique Institution where metrics are linked too. It is primarily used for drop-down fields, or where a list of all the institutions independent of metrics is desired.
Book Product Metrics Institutions Schema
This table contains metrics, organised by month and institution for which there is measured activity linked to each book.
Book Product Metrics Publisher Schema
This index contains a summary of metrics, organised by month that are linked to each publisher.
Book Product Subjects BIC Schema
This table contains metrics, organised by month and BIC subject type, that are linked to each book.
Book Product Subjects BISAC Schema
This table contains metrics, organised by month and BISAC subject type, that are linked to each book.
Book Product Subjects THEMA Schema
This table contains metrics, organised by month and THEMA subject type, that are linked to each book.
Book Product Subject Year Schema
This table contains metrics, organised by published year and month and currently just the BIC subject type, that are linked to each book.