Large Result Set Support

The Simba Google BigQuery ODBC Connector supports the AllowLargeResults option in BigQuery job configurations, enabling result sets greater than the BigQuery maximum result sizes. To store large query results, the connector creates temporary tables in BigQuery under the dataset ID specified using the Dataset Name For Large Result Sets connector configuration property. These temporary tables exist for a limited time, specified using the Temporary Table Expiration Time connector configuration property, before they are deleted.

Note:

For more information about BigQuery maximum result sizes, see "Quotas and Limits" in the Google BigQuery documentation: https://cloud.google.com/bigquery/quotas#query_jobs.

Large result sets are always supported if Standard SQL is used. If Legacy SQL is used, large result sets are only supported if the Allow Large Result Sets check box is selected or the AllowLargeResults option is set to 1.

For more information about large result sets and the limitations of this feature, see the following sections in the BigQuery documentation:

• "Queries" in Quota Policy: https://developers.google.com/bigquery/quota-policy.
• "Returning large query results" in Query Data: https://developers.google.com/bigquery/querying-data.

Note:

To enable the High-Throughput API for large result sets, select the Enable High-Throughput API check box or set the EnableHTAPI property to 1. For more information, see High-Throughput API.