CData Excel Add-In for Google BigQuery 2019 - Online Help
Questions / Feedback?

Use Storage Api

CData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354

Specifies whether to use BigQuery's Storage API for bulk data reads.

Data Type

bool

Default Value

false

Remarks

When this is set to true, the add-in will use the Storage API instead of the default REST API. Depending upon the complexity of the query, the add-in may execute the query in one of two ways:

  • Simple queries that read all columns from only one table, and have no extra clauses except LIMIT, are executed directly within the Storage API.
  • All other queries are executed as a query job which writes to a temporary table. Once the query is complete, the results are read from the temporary table using the Storage API.

The BigQuery Storage API can read data faster and more efficiently than the REST API, but is priced differently and requires extra OAuth permissions when using your own OAuth app. It also uses the separate StoragePageSize property instead of PageSize.

The BigQuery REST API requires no extra permissions and uses standard pricing, but is slower than the Storage API.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0