mars-elt/dbt/macros/get_main_task_name.sql

{% macro get_main_task_name(source_model_name) %}
    {# return({{ source_model_name | split('__')[-1] }}) #}
    {% set ret = "substr('" ~ source_model_name ~ "', 1, instr('" ~ source_model_name ~ "', '_', -1) -1)" %}
    {{ return(ret) }}
{% endmacro %}