Running your first data models

Querying the events table directly — as you would have done in the previous step — can be useful for exploring your events or building custom analytics. However, for many common use cases it’s much easier to use our data models, which provide a pre-aggregated view of your data.

We recommend dbt for data modeling. Here’s how to get started.

BDP Enterprise

Refer to the setup instructions to add and configure your models in the Console, so that they can be run automatically by Snowplow BDP.

BDP Cloud

You will need to install dbt and run the models yourself — see the “quick start” links below.

Try Snowplow

You will need to install dbt and run the models yourself — see the “quick start” links below.

Open Source

You will need to install dbt and run the models yourself — see the “quick start” links below.

Next, add your first model:

• The Web model is a good starting point for websites, providing data about page views, sessions, users, and more (quick start guide)
• The Mobile model is a good starting point for mobile applications, providing data about screen views, sessions, users, and more (quick start guide)

You can also explore the full list of available models.

Using dbt

To start using our models with dbt, you will need to create a dbt project and add the respective packages.