LargeResultDataset

Default Value Data Type Required

_simba_jdbc, if QueryDialect is set to BIG_QUERY, or if QueryDialect is set to SQL and LargeResultTable is specified.

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

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 you are using different datasets for different locations, make sure that this option is specified, and that the specified dataset is in the same region as the queried table.

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

Related topics