Error with generate_surrogate_key()

Help
1

The problem I’m having

I am stuck on an error. I want to generate surrogate key but keep getting the error below.

select {{ dbt_utils.generate_surrogate_key(
      ['date',
      'user_id',
      'type']
  ) }} as contribution_id,
....

What is wrong with my query?

What I’ve already tried

I originally was using dbt_utils.surrogate_key() but noticed that it is the older version.

I also added this var in dbt_project.yaml :
surrogate_key_treat_nulls_as_empty_strings: true #turn on legacy behaviour

But nothing worked.

Some example code or error messages

Compilation Error in model dau (models/dau.sql)
  macro 'dbt_macro__default__surrogate_key' takes not more than 1 argument(s)
2

Did you fix your error? I am facing it currently and I have no idea.

3

I faced the same issue with check_cols in a snapshot. I just ended up using CONCAT to join all the columns myself and passed that in as one parameter. It’s basically what the macro is doing anyway. You could also just cast it to any HASH function after that and have the same exact result without the macro.