Home

Awesome

🥪 The Jaffle Shop 🦘

This repo provides a production example of a dbt project containting metrics and semantic models. These resources are required to use the dbt semantic layer. To get started, follow the instructions below:

Clone the repo.

git clone git@github.com:InfuseAI/jaffle-sl-template.git
cd jaffle-sl-template

Install Metricflow

Install metricflow, et al within a virtual environment:

python -m venv .env
source .env/bin/activate
pip install "dbt-metricflow[duckdb]"
dbt --version
mf --version

Test the connection

  1. Update the profile within dbt_project.yml to refer to one of your pre-existing profile
dbt debug

Load data

dbt deps
dbt seed

Run your dbt project, and query metrics

dbt build --exclude path:jaffle-data
mf validate-configs
mf query --metrics large_orders