surrogate_key

[mikaelpaulhiout]

can you please update your package with the changes : models/staging/snowpipe/stg_snowpipe_copy_history.sql (surrogate_key => generate_surrogate_key) models/staging/snowpipe/stg_snowpipe_usage_history.sql (surrogate_key => generate_surrogate_key)

it make some warning

Thanks

[apantaz]

Any update on this? @entechlog

dbt compile generates this :

_Warning: dbt_utils.surrogate_key has been replaced by dbt_utils.generate_surrogate_key. The new macro treats null values differently to empty strings. To restore the behaviour of the original macro, add a global variable in dbt_project.yml called surrogate_key_treat_nulls_as_empty_strings to your dbt_project.yml file with a value of True. The dbt_snow_utils.stg_snowpipe__copyhistory model triggered this warning.

Temporarily we can apply the changes to the files below: models\staging\snowpipe\stg_snowpipe__copy_history.sql models\staging\snowpipe\stg_snowpipe__usage_history.sql

but this is hard coding and would work more effectively if you could change this from your side.

Thanks in advance