JDBC Driver for Google BigQuery

Build 22.0.8462

StorageTimeout

How long a Storage API connection must remain idle before the provider reconnects.

Data Type

string

Default Value

"60"

Remarks

Google BigQuery and many proxies/firewalls restrict the amount of time that idle connections stay alive before they are forcibly closed. This can be a problem when using the Storage API because the driver may stream data faster than it can be consumed. While the consumer is catching up, the driver does not use its connection and it may be closed by the next time the driver uses it.

To avoid this the driver will automatically close and reopen the connection if it has been idle for too long. This property controls how many seconds the connection has to be idle for the driver to reset it. To disable these resets this property can also set to 0 or a negative value.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462