dbt-msft / tsql-utils

dbt-utils for the dbt-msft family of packages
MIT License
25 stars 24 forks source link

Compilation error when following "Dev environment set-up" instructions in CONTRIBUTING.md #80

Open lkell opened 2 years ago

lkell commented 2 years ago

I am having trouble running integration tests for this package in my development environment. I can follow the "Dev environment set-up" instructions up to step 5, but then I encounter a Compilation Error when I try to run dbt seed or related dbt commands like run or test. The error specifies "No macro named 'except' found":

❯ dbt deps --target sqlserver
22:21:02  [WARNING]: Deprecated functionality
The `source-paths` config has been renamed to `model-paths`. Please update your
`dbt_project.yml` configuration to reflect this change.
22:21:02  [WARNING]: Deprecated functionality
The `data-paths` config has been renamed to `seed-paths`. Please update your
`dbt_project.yml` configuration to reflect this change.
22:21:02  Running with dbt=1.1.1
22:21:02  Installing ../../
22:21:02    Installed from <local @ ../../>
22:21:02  Installing ../../dbt-utils
22:21:02    Installed from <local @ ../../dbt-utils>
22:21:02  Installing ../../dbt-utils/integration_tests
22:21:02    Installed from <local @ ../../dbt-utils/integration_tests>
22:21:02  Installing ../
22:21:02    Installed from <local @ ../>

❯ dbt seed --target sqlserver --full-refresh
22:21:21  [WARNING]: Deprecated functionality
The `source-paths` config has been renamed to `model-paths`. Please update your
`dbt_project.yml` configuration to reflect this change.
22:21:21  [WARNING]: Deprecated functionality
The `data-paths` config has been renamed to `seed-paths`. Please update your
`dbt_project.yml` configuration to reflect this change.
22:21:21  Running with dbt=1.1.1
22:21:21  Partial parse save file not found. Starting full parse.
22:21:22  Encountered an error:
Compilation Error
  In dispatch: No macro named 'except' found
      Searched for: 'tsql_utils_dbt_utils_integration_tests.sqlserver__except', 'tsql_utils_dbt_utils_integration_tests.default__except', 'dbt.sqlserver__except', 'dbt.default__except'

Has anyone experienced an issue like this before or have any thoughts on how I can resolve this?

Also potentially related to this issue, I noticed that my dbt-sqlserver version is different from the 0.21.0rc1 version specified in.circleci/config.yml. I'm thinking it would be best for my dev environment to match the ci environment, but it looks the current version of dbt-utils requires dbt-core >= 1.0.0.