Running multiple macros in a transactional way

ronifintech · December 9, 2020, 7:01pm

Hi,

I’m looking to create multiple macros and then have a “master” macro to run all of the other macros together.
a couple of querstions:

is it possible to run multiple macros within one single macro?
is it possible to run multiple macros in a transactional way?
is it possible to log any errors a macro produces?

Thanks,
Roni

xzheng · September 2, 2021, 3:39pm

Hi I am in same situation. need to have a macro to call multiple macro. did you get the solution?
Thanks,
Alex

s.chaser · September 8, 2021, 11:32pm

Hi Roni, I believe they all achievable.
go to dbt_utils:

github.com

dbt-labs/dbt-utils/blob/master/macros/sql/generate_series.sql

{% macro get_powers_of_two(upper_bound) %}
    {{ return(adapter.dispatch('get_powers_of_two', 'dbt_utils')(upper_bound)) }}
{% endmacro %}

{% macro default__get_powers_of_two(upper_bound) %}

    {% if upper_bound <= 0 %}
    {{ exceptions.raise_compiler_error("upper bound must be positive") }}
    {% endif %}

    {% for _ in range(1, 100) %}
       {% if upper_bound <= 2 ** loop.index %}{{ return(loop.index) }}{% endif %}
    {% endfor %}

{% endmacro %}


{% macro generate_series(upper_bound) %}
    {{ return(adapter.dispatch('generate_series', 'dbt_utils')(upper_bound)) }}
{% endmacro %}

This file has been truncated. show original

there are lots of examples

Topic		Replies	Views
Apply Multiple Macros as Hooks on a Model Help bigquery , macros	5	9140	December 16, 2022
How to run multiple delete or update statements from 1 macro? Help	2	2281	June 12, 2023
DBT does not run macros on sequence Help macros	1	1085	May 20, 2023
Post_Hook - macro with inside_transaction set to False Archive	0	2817	September 17, 2021
Problem with UDF macro during 'run dbt' Help	1	1026	May 25, 2023

Running multiple macros in a transactional way

Related topics