Running SQL on connecting to the database

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.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.