Load and create user model via dbt source
Compared to the 10-row file for the distribution centers, the users
data file is much larger, with 125k rows, but no less critical.
The users
data file can help your stakeholders answer business critical questions such as "who are my users?" or "what kind of purchase patterns do they have?". To get the data to a clean enough state so that your data, business, and product colleagues can confidently self-service pull data to answer these questions, you will need to load the users
data into the dbt project.
However, because users
is a significantly larger file, it and the other five data files need to be loaded using dbt source
.
In this exercise, you will familiarize yourself with using the users file to practice loading a dbt source
file and building a staging model on top of it. The table has already been pre-loaded into the DuckDB database as looker_ecommerce
(schema) and users
(table name).
This exercise is part of the course
Case Study: Building E-Commerce Data Models with dbt
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
