dbt-msft/tsql-utils

CI Failing due to an Incompatible Seed on Synapse

alittlesliceoftom opened this issue · 2 comments

The CI is failing during the dbt seed stage due to an ill formatted file (for synapse), the file is formatted fine for the Azure SQL runs.

image

This means that the tests aren't running for synapse

The data is not stored in this repo, but in dbt_utils (https://github.com/fishtown-analytics/dbt-utils/blob/master/integration_tests/data/etc/data_people.csv)

A local fix could be to let dbt seed fail gracefully without raising an error to the CI and preventing the test from running. Or to identify why this file does not work and fixing that. Alternately we could --exclude the file's load, but we would also have to then exclude downstream tests which quickly gets messy.

Check out https://github.com/dbt-msft/dbt-synapse/issues/30 I think we almost have a fix

this issue is fixed now but I still have to cut a new official release and push it to PyPI