[X] I believe this is a new bug in dbt-expectations
[X] 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.
Is this a new bug in dbt-expectations?
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
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.
Additional Context