Error on incremental model build in Databricks

In-Depth Discussions
1

Hello , I am getting this error trying to build a incremental model in databricks

Cannot resolve function DBT_INTERNAL_SOURCE.md5 on search path

detailed error

merge into dev.default.cl_injury_claim as dbt_INTERNAL_DEST
using cl_injury_claim__dbt_tmp as dbt_INTERNAL_SOURCE
on
dbt_INTERNAL_SOURCE.md5(cast(concat(coalesce(cast(claim_id as string), ‘dbt_utils_surrogate_key_null’), ‘-’, coalesce(cast(update_num as string), ‘dbt_utils_surrogate_key_null’)) as string)) = dbt_INTERNAL_DEST.md5(cast(concat(coalesce(cast(claim_id as string), ‘dbt_utils_surrogate_key_null’), ‘-’, coalesce(cast(update_num as string), ‘dbt_utils_surrogate_key_null’)) as string))

  when matched then update set
     * 

  when not matched then insert *

15:55:58 Databricks adapter: <class ‘databricks.sql.exc.ServerOperationError’>: [UNRESOLVED_ROUTINE] Cannot resolve function DBT_INTERNAL_SOURCE.md5 on search path [system.builtin, system.session, dev.default].; line 17 pos 14
15:55:58 Databricks adapter: diagnostic-info: org.apache.hive.service.cli.HiveSQLException: Error running query: [UNRESOLVED_ROUTINE] org.apache.spark.sql.AnalysisException: [UNRESOLVED_ROUTINE] Cannot resolve function DBT_INTERNAL_SOURCE.md5 on search path [system.builtin, system.session, dev.default].; line 17 pos 14