dbt/include/maxcompute/macros/utils/hash.sql

{% macro maxcompute__hash(expression) -%}
    case when {{ expression }} = NULL
        then md5('')
    else
        md5({{ expression }})
    end
{%- endmacro %}