Breaking News: Grepper is joining You.com. Read the official announcement!

dbt macro chech if a col is null

Envious Eland answered on May 28, 2022 Popularity 1/10 Helpfulness 1/10

answer dbt macro chech if a col is null

dbt macro chech if a col is null

Comment

{% macro safe_concat(field_list) %}
  {# Takes an input list and generates a concat() statement with each argument in the list safe_casted to a string and wrapped in an ifnull() #}
  concat({% for f in field_list %}
    ifnull(safe_cast({{ f }} as string), '')
    {% if not loop.last %}, {% endif %}
  {% endfor %})
{% endmacro %}

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: discourse.getdbt.com

Tags: col dbt null whatever

Link to this answer
Share Copy Link