package - DBT - Error when calling audit_helper.compare_relations() macro - Stack Overflow

admin管理员组

文章数量:1323200

I'm trying to test a macro from audit_helper package. Got it from DBT Hub.

I ran an audit referencing this macro (seen in the package documentation):

Code:

set old_etl_relation=ref("customers_orders") -%}

set dbt_relation=ref("fct_customers_orders") %}

if execute %}
audit_helperpare_relations(
a_relation=old_etl_relation,
b_relation=dbt_relation,
primary_key="order_id"
) }}
endif %}

But I'm facing this error:

    Compilation Error in sql_operation t_5cc581bfcba4473fae6af43932acc239 (from remote system.sql)
In dispatch: No macro named 'get_filtered_columns_in_relation' found within namespace: 'dbt_utils' Searched for: 'snowflake__get_filtered_columns_in_relation', 'default__get_filtered_columns_in_relation' > in macro get_filtered_columns_in_relation (macros\sql\get_filtered_columns_in_relation.sql) > called by macro compare_relations (macros\compare_relations.sql) > called by sql_operation t_5cc581bfcba4473fae6af43932acc239 (from remote system.sql)

Note that I'm using dbt-core in visual code studio, and there's no other issues with compiling and building models.

Thanks for the help.

The packages seems to be correctly imported.

package.yml:

packages:
package: dbt-labs/dbt_utils
version: 1.3.0
package: dbt-labs/audit_helper
version: 0.12.1

I ran correctly : 1 - dbt clean 2 - dbt deps

本文标签： packageDBTError when calling audithelpercomparerelations() macroStack Overflow