dbt_fivetran_utils icon indicating copy to clipboard operation
dbt_fivetran_utils copied to clipboard

[FEATURE] - update_persist_pass_through_columns to include field aliasing

Open fivetran-reneeli opened this issue 2 years ago • 0 comments

Update the titular macro with this as the default. This is to allow for the case where we wish to append anything to any pass through fields. We ran into this in salesforce where we were joining 1 table twice, and ran into problems with ambiguous columns. The below is Joe's fix for specifying which table a field is coming from.


{% macro custom_persist_pass_through_columns(pass_through_variable, identifier=none, transform='', append_string='') %}

{% if var(pass_through_variable, none) %}
    {% for field in var(pass_through_variable) %}
        , {{ transform ~ '(' ~ (identifier ~ '.' if identifier else '') ~ (field.alias if field.alias else field.name) ~ ')' }} as {{ field.alias if field.alias else field.name }}{{ append_string }}
    {% endfor %}
{% endif %}

{% endmacro %}

fivetran-reneeli avatar May 02 '23 21:05 fivetran-reneeli