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: dbt test fails when column name is a keyword #116

Open
sip9522 opened this issue Jul 26, 2022 · 0 comments
Open

BUG: dbt test fails when column name is a keyword #116

sip9522 opened this issue Jul 26, 2022 · 0 comments

Comments

@sip9522
Copy link

sip9522 commented Jul 26, 2022

dbt test fails on not_null test when column name is a keyword e.g. order, with the following error message:

An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: Queries of this type are not supported

Column and column test definition from .yml file:

columns:
   - name: order     
     tests:
         - not_null

Compiled column not_null test

select
    order
from dwh.table
where 
    order is null

Maybe this can be solved by quoting the column names in the compiled test sql? E.G

select
    "order"
from dwh.table
where 
    "order" is null
nicor88 added a commit to Avinash-1394/dbt-athena that referenced this issue Jan 22, 2023
…omme#116)

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Co-authored-by: nicor88 <[email protected]>
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