Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] The quote: parameter in the model .yaml breaks the expect_column_to_exist() macro. #285

Open
2 tasks done
jcoombes opened this issue Sep 19, 2023 · 0 comments
Open
2 tasks done

Comments

@jcoombes
Copy link

Is this a new bug in dbt-expectations?

  • I believe this is a new bug in dbt-expectations
  • I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

When the model.yml has a column field which specifies quote: true - this macro returns non-zero (one) row, even though other tests pass e.g. not_null.

Expected Behavior

When the model.yml has a column field which specified quote: true - this macro returns zero rows if the column exists and non-zero rows if the column doesn't exist.

Steps To Reproduce

Postgres database
column named with SCREAMING_SNAKE_CASE
model.yaml specifies the quote: true parameter
model.yaml specifies the tests: dbt_expectations.expect_column_to_exist and not_null

not_null passes, expect_column_to_exist fails.

Relevant log output

None

Environment

- OS:
- Python:
- dbt:
- dbt-expectations:

Which database adapter are you using with dbt?

dbt-postgres

Note: dbt-expectations currently does not support database adapters other than the ones listed below.

  • Postgres
  • Snowflake
  • BigQuery

Additional Context

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant