You can use transactions with the Arrow Flight SQL Connector (SERVER execution type) for data persistence operations that run on a single driver node (single connector instance).
At this time, transactions support only a single driver node. If your workload distributes data uploads across multiple driver nodes, transactions support is unavailable.