Allow Large Result Sets
AllowLargeResults
| Key Name | Default Value | Required |
|---|---|---|
|
|
|
No |
Description
This option specifies the connector's response to query results larger than the BigQuery maximum result sizes when using Legacy SQL.
-
1)1: The connector allows query results that are larger than the BigQuery maximum result sizes. -
0)0: The connector returns an error when query results are larger than the BigQuery maximum result sizes.
Note:
- If this option is enabled, you must also specify a dataset for storing the temporary tables.
-
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.
- Dataset Name For Large Result Sets
- LargeResultsTemporary Table Expiration Time on page 1
- Advanced Driver Configuration Options on page 1
- Large Result Set Support
- Language Dialect
- Configuring Advanced Options
- Creating a Data Source Name
- Configuring a DSN-less Connection
- Using a Connection String