dbt-audit-helper icon indicating copy to clipboard operation
dbt-audit-helper copied to clipboard

Published 20 hours ago • verified publisher icon dbt-labs

Fix ambiguous column name warning

Open cecil185 opened this issue 3 years ago • 0 comments

When using this package, I got an ambiguous column name warning message from audit_helper/macros/compare_relation_columns.sql line 24 "full outer join b_cols using (column_name)"

I believe this can be fixed by joining with 'on' rather than 'using' - "full outer join b_cols on a_cols.column_name = b_cols.column_name"

cecil185 avatar Jan 25 '22 14:01 cecil185