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')}}
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')}}