AllowLargeResults
| Default Value | Data Type | Required |
|---|---|---|
|
|
Integer |
No |
Description
This option specifies whether the connector supports query results larger than 128MB when working in legacy SQL (the QueryDialect property is set to BIG_QUERY).
1: The connector allows query results that are larger than 128MB in size.0: The connector returns an error when query results are larger than 128MB in size.
When working in standard SQL (the QueryDialect property is set to SQL), this option is always considered to be enabled.
Important:
When this property is enabled for legacy SQL, all query results are written to and read from the destination tables, regardless of the query and its result size. Because of this, the result cache is not available to subsequent queries, and you are billed for every query that you make.
For detailed information about how the connector stores large result sets, see Large Result Set Support.