Specifies the minimum number of rows a query must return for the provider to use the Google BigQuery Storage API to read results.

データ型

string

デフォルト値

"100000"

解説

This property is only applicable when UseStorageAPI is set to true.

When UseStorageAPI is true, the 本製品 attempts to use the Google BigQuery Storage API for efficient result retrieval. If a query is too complex to run directly on the Storage API, the 本製品 creates a query job and stores the results in a temporary table.

This property defines the minimum number of rows the job must return for the 本製品 to use the Storage API to read from that table. If the result set contains fewer rows than the specified value, the 本製品 returns the results directly without using the Storage API.

Valid values range from 1 to 100,000. For example: StorageThreshold=50000

This means the Storage API will be used only if the query job returns 50,000 rows or more. Setting a lower value allows more queries to use the Storage API which may improve performance for smaller result sets, but could increase API costs. Setting a higher value limits Storage API usage to only large result sets, which can help control usage and cost, but may result in slower performance for medium-sized queries.

This property has no effect on queries that can be executed directly on the Storage API, as those do not require query jobs. Adjust this setting based on the typical size of your query results.