Google BigQuery

ExpandedToggleIcon        Connection Dialog


To connect to Google BigQuery, you need to perform the following steps:

1.Click the Web Login button
2.In the opened Web Login dialog box sign in to your Google account.
3.Click Allow.
4.Specify the IDs of the Google Cloud Platform Project and its Dataset to connect to.
5.Optionally change the name of the cloud storage bucket to use for uploading temporary CSV files when loading data to Google BigQuery.


Additionally you may configure Advanced connection options for more fine connection tuning.


ExpandedToggleIcon        Advanced Connection Options

The following table describes the options that you can include in the Connection String using the Advanced Connection Editor dialog box:




Client Id

The client ID obtained from the Google Developers Console.

Client Secret

The client secret obtained from the Google Developers Console.

Connection Lifetime

When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. The default value is 0 (connection always returns to pool).

Connection Timeout

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 15.

Data Set Id

The unique Id of a Dataset you want to connect to.

Default Cloud Storage Bucket

A bucket to use for temporary CSV files when loading data to Google BigQuery. The files are automatically deleted after loading is finished.

Default Command Timeout

The time in seconds to wait while trying to execute a command before terminating the attempt and generating an error. 0 indicates no limit.

Max Pool Size

The maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.

Min Pool Size

The minimum number of connections allowed in the pool. The default value is 0.

Persist Security Info

Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.


If true, by default, the connection is drawn from the appropriate pool or is created and added to the appropriate pool.

Primary Key Column

The name of a column that is considered as a primary column of a table.

Google BigQuery does have primary keys. You should specify the name of a column that Devart SSIS Data Flow Components will consider a primary key. Note that it is the same for all the tables accessed via this connection, and thus, all the BigQuery tables you are going to access via this connection must have a column with the same name, for example, ID, that is considered a primary key.

Project ID

The unique ID of a Google Cloud Platform Project associated with the connection.

Proxy Host

The host name or IP address of proxy server.

Proxy Password

The password for the proxy server account.

Proxy Port

The port number of the proxy server. The default value is 3128.

Proxy User

The proxy server account name.


If set to True, the connection allows only reading data (only SELECT statements).

Refresh Token

The refresh token returned from the authorization code exchange.

Use Legacy SQL

Determines whether to use BigQuery's legacy SQL dialect. The default value is false.

UTC Dates

Determines whether to treat date values as UTC dates. The default value is false.