I am a newbie in the dbt community and learning on dbt Learn on demand.
Even though it seems quite straightforward, I have been through many frustrations because I apply exercises on BigQuery with dbt CLI.
Right now, I am at Packages/Packages with macros stage and even though I just thoroughly follow the instructions; the extension is not working for the date_spine function and here follows the error (with the copy/pasted values in the official documentation of date_spine):
Runtime Error Database Error in model all_dates (models/marts/core/all_dates.sql) Function not found: dateadd; Did you mean date_add? at [8:14]
Therefore, I went on the extension’s git repo and had a look if any issue related to BigQuery; there is indeed one issue but it has been closed since and I cannot find any real solution in that issue thread.
Has anybody an idea what I can do to use that function?
Thanks a lot in advance!