Arrow Fallback To JSON (ArrowFallbackToJson): Arrow Fallback To JSON can be configured to allow the driver to fall the JSON query format when the arrow format is not properly initialized (ArrowFallbackToJson=0 | 1). By falling back to JSON query format, the driver can continue to execute queries that would normally return an exception; however, there is a significant performance tradeoff from not using the high-speed arrow transfer. For ideal performance, configure your JVM properly by specifying the --add-opens=java.base/java.nio=ALL-UNNAMED option value and disable this connection option (ArrowFallbackToJson= 2).

JVM Arguments (JVMArgs): This connection option can be used to address memory and performance concerns by adjusting the max Java heap size. By increasing the max Java heap size, you increase the amount of data the driver accumulates in memory. This can reduce the likelihood of out-of-memory errors and improve performance by ensuring that result sets fit easily within the JVM's free heap space.