truncate via NIFI to redshift

[#1]

Hello I can query using our JDBC driver to redshift just fine, but when I try a truncate using the same pool, it won't allow the query and errors with a note saying its not possible with "auto commit turned on" - I can not see how to turn auto commit off.