'compare_column_values' not able to create output table

heberbrandao commented 1 year ago

Describe the bug

When executing dbt run on the audit file, the output brings an error on the table creation.

Steps to reproduce

Expected results

I expected to see, how the change in my attribution model will affect production once merged.

Actual results

The library does not finish the job.

Screenshots and log output

14:33:15  Database Error in model audit_attribution (#####)
14:33:15    syntax error at or near ")"
14:33:15    LINE 25:   );
14:33:15               ^
14:33:15  
14:33:15  Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

System information

The contents of your packages.yml file:

Which database are you using dbt with?

[ ] postgres
[x] redshift
[ ] bigquery
[ ] snowflake
[ ] other (specify: ____)

The output of dbt --version:

Core:
  - installed: 1.4.1
  - latest:    1.5.0 - Update available!

  Your version of dbt-core is out of date!
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:
  - redshift: 1.4.0 - Up to date!
  - postgres: 1.4.1 - Update available!

The operating system you're using:

The output of python --version:

Additional context

Are you interested in contributing the fix?

github-actions[bot] commented 1 year ago

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

github-actions[bot] commented 1 year ago

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

dbt-labs / dbt-audit-helper