BigQuery
This section provides a complete list of the BigQuery properties you can configure in the connection settings for this provider.
| Property | Description |
| AllowLargeResultSets | Whether or not to allow large datasets to be stored in temporary tables for large datasets. |
| DestinationTable | This property determines where query results are stored in Google BigQuery. |
| UseQueryCache | Specifies whether to use Google BigQuery's built-in query cache. |
| PageSize | The number of results to return per page from Google BigQuery. |
| PollingInterval | This determines how long to wait in seconds, between checks to see if a job has completed. |
| AllowUpdatesWithoutKey | Whether or not to allow update without primary keys. |
| FilterColumns | Please set `AllowUpdatesWithoutKey` to true before you could use this property. |
| UseLegacySQL | Specifies whether to use BigQuery's legacy SQL dialect for this query. By default, Standard SQL will be used. |
| PrivateEndpointName | When connecting over Private Access, this property specifies the name of the custom endpoint. |