This transform pulls data about user roles from Salesforce; user roles are used to define access levels and permissions in Salesforce.
with user_role as (
select
_fivetran_deleted,
_fivetran_synced,
developer_name,
id as user_role_id,
name as user_role_name,
opportunity_access_for_account_owner,
parent_role_id,
rollup_description
from salesforce.user_role
)
select *
from user_role
where not coalesce(_fivetran_deleted, false)
LIMIT 100