{% macro standardize_grants_dict(grants_table) %}
    {#- /*
     This macro is ALMOST copy-paste from Snowflake DBT adapter function standardize_grants_dict.
     It is adapted to be DBT macro
    */ -#}
    {% set grants_dict = {} %}

    {% for row in grants_table %}
        {% set grantee = row["grantee_name"] %}
        {% set granted_to = row["granted_to"] %}
        {% set privilege = row["privilege"] %}
        {% if privilege != "OWNERSHIP" and granted_to != "SHARE" %}
            {% set sf_grantee -%}
                {{ granted_to.replace('_', ' ') }} {{ grantee }}
            {%- endset %}
            {% if privilege in grants_dict.keys() %}
                {% do grants_dict[privilege].append(sf_grantee) %}
            {% else %}
                {% do grants_dict.update({privilege: [sf_grantee]}) %}
            {% endif %}
        {% endif %}
    {% endfor %}

    {{ return(grants_dict) }}
{% endmacro %}

{% macro snowflake__apply_grants(relation, grant_config, should_revoke=True) %}
    {#- /*
     This macro is ALMOST copy-paste from standard DBT macro with the same name.
     It aims at fixing grants in Snowflake as they are different from the way DBT applies grants:
     1. Snowflake syntax is different:
       Standard DBT: grant <privilege> on <object> to <role>
       Snowflake;s:  grant <privilege> on <object> to <role_type> <role>, where role type is either ROLE or DATABASE ROLE
     2, Snowflake's adapter function standardize_grants_dict(current_grants_table) returns no information if
          an object was granted to ROLE or DATABASE ROLE
    */ -#}
    {#-- If grant_config is {} or None, this is a no-op --#}
    {% if grant_config %}
        {% if should_revoke %}
            {#-- We think previous grants may have carried over --#}
            {#-- Show current grants and calculate diffs --#}
            {% set current_grants_table = run_query(get_show_grant_sql(relation)) %}
            {% set current_grants_dict = standardize_grants_dict(current_grants_table) %}
            {% set needs_granting = diff_of_two_dicts(grant_config, current_grants_dict) %}
            {% set needs_revoking = diff_of_two_dicts(current_grants_dict, grant_config) %}
            {% if not (needs_granting or needs_revoking) %}
                {{ log('On ' ~ relation ~': All grants are in place, no revocation or granting needed.')}}
            {% endif %}
        {% else %}
            {#-- We don't think there's any chance of previous grants having carried over. --#}
            {#-- Jump straight to granting what the user has configured. --#}
            {% set needs_revoking = {} %}
            {% set needs_granting = grant_config %}
        {% endif %}
        {% if needs_granting or needs_revoking %}
            {% set revoke_statement_list = get_dcl_statement_list(relation, needs_revoking, get_revoke_sql) %}
            {% set grant_statement_list = get_dcl_statement_list(relation, needs_granting, get_grant_sql) %}
            {% set dcl_statement_list = revoke_statement_list + grant_statement_list %}
            {% if dcl_statement_list %}
                {{ call_dcl_statements(dcl_statement_list) }}
            {% endif %}
        {% endif %}
    {% endif %}
{% endmacro %}