The problem I’m having
How can we set certain session properties when dbt connects to our redshift database?
Specifically we need to be able to run this SQL.
set pg_federation_repeatable_read to off
Disregard… I finally found the documentation in redshift to alter the default session properties for a user.