Dataset Name For Large Result Sets

LargeResultsDataSetID

Key Name Default Value Required

LargeResultsDataSetId

None (but see Use Default _bqodbc_temp_tables Large Results Dataset)

No

Description

The ID of the BigQuery dataset that you want to use to store temporary tables for large result sets. Only specify a value for this option if you want to enable support for large result sets.

Note:

  • If the UseDefaultLargeResultsDataset property is enabled, it overrides this value.
  • If this dataset does not exist and the data store specifies the US region, the connector creates the dataset.
  • If you want to use large result sets with Legacy SQL, you must also enable the Allow Large Result Sets option.