How to override SET command parameters for subsequent processes

Question

Can I connect to Redshift with JDBC connector and use SET command to override settings for subsequent processes?
https://docs.aws.amazon.com/redshift/latest/dg/r_SET.html

Answer

You can override parameters set at the beginning of a transaction by enclosing the subsequent processes in the transaction.
It might also be possible to override them without a transaction.

However, we cannot ensure that all operations behave as above.
It is more reliable to set parameters for each operation with SET command.

Transaction
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/flow_transaction.htm

Related FAQs

The Timing of a session start and end in JDBC connector