Can I Set a Session Variable for a PostgreSQL Connection?

Question

I have a table that requires a specific session variable for access. Can I configure my Fivetran PostgreSQL connection to set this variable?

Environment

All PostgreSQL Connectors

Answer

No, Fivetran doesn't support setting custom session variables, such as SET LOCAL app.variable_name = ..., while setting up PostgreSQL connections.