Google BigQuery Connectors > Part I: Introduction to Google BigQuery connectors > Connector comparison > Source functionality
  

Source functionality

When you import an object from Google BigQuery to read data, you can configure the advance source properties to determine the read operation behavior. For example, you can read data in staging mode or you can configure pre-SQL and post-SQL configurations.
The following table lists the source functionality you can use when you read data from an Google BigQuery source for Google BigQuery and Google BigQuery V2 connectors:
Feature
Google BigQuery Connector
Google BigQuery V2 Connector
Custom query
No
Yes
Legacy SQL for custom query
No
Yes
Region ID
No
Yes
Allow Large Results
Yes
Yes
Query results destination table
Yes
Yes
Persist query results destination table
Yes
Yes
Job poll interval
Yes
Yes
Read mode - direct
Yes
Yes
Read mode - staging
Yes
Yes
Local staging file directory
Yes
Yes
Multiple threads for downloading staging files
Yes
Yes
Staging file compression
Yes
Yes
Pre-SQL and pre-SQL configurations
Yes
Yes
Post-SQL and post-SQL configurations
Yes
Yes
SQL override query
No
Yes
Legacy SQL for SQL override query
No
Yes
Retry Options
No
Yes