How to pass a hardcoded string to surrogate key function

You can use double quotes and single quotes to achieve this:

select 	{{ dbt_utils.generate_surrogate_key(['customer_id', "'My Sales System'"]) }},
		*
from    {{ source('datalake', 'customers')}}
1 Like