Use Default _bqodbc_temp_tables Large Results Dataset
UseDefaultLargeResultsDataset
| Key Name | Default Value | Required |
|---|---|---|
|
|
|
No |
Description
This option specifies whether the connector uses a default dataset to store temporary tables for large result sets if no dataset is specified and the data store specifies the US region.
-
1)1: The connector uses a default large result dataset of _bqodbc_temp_tables. -
0)0: The connector does not use a default large result dataset. If no dataset is specified, large result support is not enabled.
Note:
- If this value is specified, it overrides the
LargeResultsDatasetIdproperty. - If this option is selected, the data store specifies the US region, and the _bqodbc_temp_tables dataset does not exist, the connector creates this dataset.
- If you want to use large result sets with Legacy SQL, you must also enable the Allow Large Result Sets option.
- Dataset Name For Large Result Sets
- LargeResultsTemporary Table Expiration Time on page 1
- Advanced Driver Configuration Options on page 1
- Large Result Set Support
- Language Dialect
- Configuring Advanced Options
- Creating a Data Source Name
- Configuring a DSN-less Connection
- Using a Connection String