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] Table columns names that contain spaces trigger runtime errors. #302

Open
2 tasks done
pulsation opened this issue Mar 8, 2024 · 0 comments
Open
2 tasks done

Comments

@pulsation
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

Table columns names that contain spaces trigger runtime errors such as : Parser Error: syntax error at or near "Index".

Expected Behavior

While it's weird to have table columns containing spaces, they should not trigger errors. Enclosing table column names with "s may fix this.

Steps To Reproduce

Add a dbt_expectations.expect_column_values_to_not_be_in_set on a column that contains one or more spaces.

Relevant log output

18:15:16 Runtime Error in test dbt_expectations_expect_column_values_to_not_be_in_set_volumes_2008_Price_Index__ERR__NA______blank_ (models/schema.yml)
Parser Error: syntax error at or near "Index"

Environment

- OS: MacOS 12.7.3
- Python: 3.12.2
- dbt: 1.7.9
- dbt-expectations: 0.10.3

Which database adapter are you using with dbt?

DuckDB, but Postgres also has this problem.

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