Excel Add-In for Google BigQuery

Build 23.0.8839

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 add-in may stream data faster than it can be consumed. While the consumer is catching up, the add-in does not use its connection and it may be closed by the next time the add-in uses it.

To avoid this the add-in 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 add-in to reset it. To disable these resets this property can also set to 0 or a negative value.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839