Specifies the number of rows to buffer per page when executing queries using the Google BigQuery Storage API.

Data Type

string

Default Value

"10000"

Remarks

This property applies only when UseStorageAPI is enabled and the query is eligible to run on the Google BigQuery Storage API. It controls how many rows the server retrieves and buffers from the API in each page.

Larger values typically improve performance by reducing the number of round trips to the API, but will increase memory consumption. Smaller values reduce memory usage but may slow down query execution due to more frequent network calls.

Adjust this value based on your environment’s memory capacity and performance needs. For large, high-throughput queries, increasing the value may help. For resource-constrained systems, consider lowering it.