Specifies whether to use the Google BigQuery Storage API for bulk data reads instead of the standard REST API.

データ型

bool

デフォルト値

true

解説

When this property is set to true, the 本製品 uses the Google BigQuery Storage API, which is optimized for high-throughput, low-latency data access.

Depending on the complexity of the query, the 本製品 chooses one of two execution paths:

• Direct execution via the Storage API is used for simple queries that meet all of the following conditions:
  • Read all columns
  • Reference only one table
  • Contain no clauses other than LIMIT
• Query jobs whose results are read using the Storage API are used for all other queries. The 本製品 submits a query job, stores the result in a temporary table, and uses the Storage API to read the result.

The Storage API typically offers better performance than the REST API but:

• Requires additional OAuth scopes when using a custom OAuth app
• Uses the StoragePageSize property instead of PageSize

If this property is set to false, the 本製品 uses the Google BigQuery REST API, which:

• Requires no extra permissions
• Uses standard pricing
• Is slower and less efficient for large result sets

Keep this property enabled for faster and more efficient data access, especially when working with large datasets. Disable it only if you require simpler authentication or need to reduce dependency on the Storage API.