Specifies whether large result sets are allowed to be stored in temporary tables.

Data Type

bool

Default Value

false

Remarks

When set to true, the server permits queries that return large result sets to write results to a temporary table. This is required when query results exceed Google BigQuery’s default response limits.

When set to false, large result sets may cause queries to fail unless pagination or result limiting is used.

Enable this property if you expect queries to return large datasets and want the server to store those results using temporary tables in Google BigQuery.

Storing large result sets in temporary tables may increase query execution time and storage usage. Enable this option only when necessary.