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