LargeResultTable

Default Value Data Type Required

A value consisting of the prefix temp_table_ followed by the time of table creation, if QueryDialect is set to BIG_QUERY, or if QueryDialect is set to SQL and LargeResultDatasetSet is specified.

None, if QueryDialect is set to SQL and no value is provided for LargeResultDataSet.

String

No

Description

A persistent destination dataset for storing query results. For more information, see Large Result Set Support.

Important:

Important:

If you specify a persistent destination table and dataset, 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 for subsequent queries, and you are billed for every query that you make.

If QueryDialect is set to BIG_QUERY, this option is only used when the AllowLargeResults property is enabled.