Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise