Specifies the number of results to return per page from Google BigQuery when paging through query results.

データ型

string

デフォルト値

"100000"

解説

This property controls how many rows are returned in each page of results from Google BigQuery. A higher value reduces the number of HTTP requests by returning more data at once, but may increase response time and memory usage. A lower value returns fewer rows per page and requires more requests, which may help avoid timeouts or reduce memory usage in constrained environments.

This property has no effect when UseStorageAPI is enabled and the query is eligible to use the Google BigQuery Storage API. In that case, use StoragePageSize to control paging behavior.

Adjust this property to balance throughput and stability based on your workload and network environment.

Larger page sizes reduce request overhead, but may increase the risk of timeouts. Smaller sizes improve reliability at the cost of increased request frequency.