Skip to content

Instantly share code, notes, and snippets.

View mirnawong1's full-sized avatar

Mirna Wong mirnawong1

View GitHub Profile
@jeremyyeo
jeremyyeo / dbt_jinja_list_adding_control_structure.sql
Last active October 1, 2021 09:44
Conditionally adding things to a list in a dbt macro
{% macro test_macro() %}
{% set contains_1 = [] %}
{% set contains_2 = [] %}
{% set my_dict = [{'a': [1]}, {'b': [1, 2]}, {'c': [2]}] %}
{% for item in my_dict %}
{{ log(item, info=True) }}