Search⌘ K
Home
Courses
Learn Data Build Tools ( DBT )

Coding Challenge: Pack Your Macro

Complete this hands-on exercise to pack a macro inside a package and import it into your project.

We'll cover the following...

Problem

Here’s a macro that groups by a column and counts distinct values of a field:

MySQL
{% macro daily_count(field_to_count) %}
SELECT 
    order_date, 
    COUNT(DISTINCT {{field_to_count}} ) AS {{field_to_count}}
FROM {{ ref("orders") }}
GROUP BY order_date
{% endmacro %}

As this macro is ...