I’m trying to run a model with for our load framework which is essential to our ops but returns errors. The model has some macros in the background.
The model isn’t running anymore after I upgraded dbt from 1.0 to 1.6.
Example code or error messages
Compilation Error in model mtd_table_config models\metadata\load\tables\mtd_table_config.sql)
11:35:17 macro 'dbt_macro__get_delete_insert_merge_sql' takes not more than 4 argument(s)
11:35:17
11:35:17 > in macro default__get_incremental_delete_insert_sql (macros\materializations\models\incremental\strategies.sql)
11:35:17 > called by macro get_incremental_delete_insert_sql (macros\materializations\models\incremental\strategies.sql)
11:35:17 > called by macro statement (macros\etc\statement.sql)
11:35:17 > called by macro materialization_incremental_snowflake (macros\materializations\incremental.sql)
11:35:17 > called by macro materialization_incremental_snowflake (macros\edr\materializations\model\incremental.sql)
11:35:17 > called by model mtd_load_table_config (models\metadata\load\tables\mtd_load_table_config.sql)
What I’ve already tried - edited
downgraded: I now know that with dbt 1.3 works but isn’t working with 1.4. Gives exact same errors. It points out to these macros that can be found here:
C:\Users\UID\Anaconda3\envs\dbt-1.5\Lib\site-packages\dbt\include\global_project\macros\materializations\models\incremental
I don’t understand why this is happening. Maybe because in 1.4 there are some new incremental_predicates?
Help would be greatly appreciated.