Instead of including devices in every table, I thought it to be more ergonomic to create a devices model that can be joined to in order to add those dimensions to a query.
This also takes advantage of the doc macro that DBT recommends to keep documentation for similar columns consistent.
This adds two new models:
clicks- all click events and relevant columns.devices- the latest snapshot of every device.Instead of including devices in every table, I thought it to be more ergonomic to create a
devicesmodel that can be joined to in order to add those dimensions to a query.This also takes advantage of the
docmacro that DBT recommends to keep documentation for similar columns consistent.