search

dbt-msft / tsql-utils

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

CI Failing due to an Incompatible Seed on Synapse #13

Closed alittlesliceoftom closed 3 years ago

alittlesliceoftom commented 3 years ago

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.

dataders commented 3 years ago

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

dataders commented 3 years ago

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