Excel Add-In for Google BigQuery

Build 24.0.9175

StorageTimeout

How long a Storage API connection may remain active before the provider reconnects.

Data Type

string

Default Value

"300"

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 active for too long. This property controls how many seconds the connection has to be active for the add-in to reset it. To disable these resets this property can also be set to 0 or a negative value.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175