Cmdlets for Google BigQuery

Build 23.0.8839

StorageTimeout Parameter (Connect-GoogleBigQuery Cmdlet)

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

Syntax

Connect-GoogleBigQuery -StorageTimeout string

Data Type

cstr

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

To avoid this the cmdlet 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 cmdlet 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