dbt-msft / tsql-utils

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

Bug fix proposal on issue related to #96 #100

Closed joaquinbravo23 closed 4 weeks ago

joaquinbravo23 commented 9 months ago

I was having an issue working with dbt_utils.date_spine, getting the following error:

image

By making this change the macro worked as expected

dbt_utils.dateadd to dbt.dateadd dbt_utils.datediff to dbt.datediff

I believe this error is due to the following:

As of dbt 1.3 and dbt_utils 1.0, cross-database macros have moved out of dbt_utils and into the main adapter code (source), so you can just dbt.datediff()and it will work. -https://stackoverflow.com/questions/75528600/dbt-datediff-dict-object-compilation-errors

Working as expected image