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

unable to use camel case postgres columns with soda contracts #2053

Open
TianyuanCai opened this issue Apr 14, 2024 · 1 comment
Open

unable to use camel case postgres columns with soda contracts #2053

TianyuanCai opened this issue Apr 14, 2024 · 1 comment
Assignees
Labels
contract Data contracts

Comments

@TianyuanCai
Copy link

When evaluating contracts, camel cased columns such as countryId doesn't get double-quoted before being templated into the sql query. As a result, this column won't be recognized, and the query would fail. I've tried several ways of escaping the quote in yaml to no avail. Do you have any suggestions for how to perform validation on camel case columns?

dataset: country

columns:
  - name: name
    checks: 
      - type: no_missing_values
  - name: countryId
    checks: 
      - type: no_missing_values
@tools-soda
Copy link

SAS-3231

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
contract Data contracts
Projects
Status: In Progress
Development

No branches or pull requests

3 participants