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

No option for quoting in equality test? #985

Open
nickvd43 opened this issue Feb 11, 2025 · 0 comments
Open

No option for quoting in equality test? #985

nickvd43 opened this issue Feb 11, 2025 · 0 comments
Labels
bug Something isn't working triage

Comments

@nickvd43
Copy link

Describe the bug

We are using DBT together with snowflake and for some unit tests we'd like to make use of the equality test to compare results in our tables to expected results. Our column names are usually quoted and in snake_case (lower). However the equality test seems to not have the option to quote column names. Leading to issues in the test where it is trying to look for unquoted column names which are interpreted as capital letters (and thus doesn't work)

Steps to reproduce

create two tables in snowflake with lower case column names (using quotes) and run the equality test on these two tables. this will lead to column names not being found

Expected results

I would expect the test to have the option to add quotes to identifiers of columns (as other tests have too)

Actual results

Error such as: ```
SQL compilation error: error line 43 at position 11
invalid identifier 'USER_NAME


### System information
**The contents of your `packages.yml` file:**

packages:
  - package: dbt-labs/dbt_utils
    version: 1.3.0


**Which database are you using dbt with?**
- [ ] postgres
- [ ] redshift
- [ ] bigquery
- [x] snowflake
- [ ] other (specify: ____________)


**The output of `dbt --version`:**
latest (1.9)


### Are you interested in contributing the fix?
yes 
@nickvd43 nickvd43 added bug Something isn't working triage labels Feb 11, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working triage
Projects
None yet
Development

No branches or pull requests

1 participant