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

Closed
TianyuanCai opened this issue Apr 14, 2024 · 2 comments
Closed

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

TianyuanCai opened this issue Apr 14, 2024 · 2 comments
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

@tombaeyens tombaeyens self-assigned this Apr 16, 2024
@tombaeyens tombaeyens added the contract Data contracts label Apr 16, 2024
@tombaeyens tombaeyens moved this to Todo in Contracts Apr 18, 2024
@tombaeyens tombaeyens moved this from Todo to In Progress in Contracts Apr 25, 2024
@tombaeyens
Copy link
Contributor

Duplicate of #2108

@tombaeyens tombaeyens marked this as a duplicate of #2108 Jun 26, 2024
@github-project-automation github-project-automation bot moved this from In Progress to Done in Contracts Jun 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
contract Data contracts
Projects
Status: Done
Development

No branches or pull requests

3 participants