Location Connection for Google BigQuery

This section lists and describes the connection parameters required for creating Google BigQuery location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Google BigQuery location, see Google BigQuery Requirements.

Field	Description	Equivalent Location Property
GOOGLE CLOUD PROJECT	ID of the google cloud project. For more information about google cloud projects, refer to Creating and Managing Projects in BigQuery Documentation.	GCloud_Project
BIGQUERY REGION	Geographic location of the dataset. For more information about dataset locations, refer to Dataset Locations in BigQuery Documentation. Examples: US, europe-west4, us-west4	BigQuery_Region
DATASET	Name of the dataset in Google BigQuery.	Database_Name
AUTHENTICATION METHOD	Authentication method for connecting HVR to the Google BigQuery server. Environment variable GOOGLE_APPLICATION_CREDENTIALS: Authentication (OAuth) using the credentials (service account key) fetched from the environment variable GOOGLE_APPLICATION_CREDENTIALS. For more information about setting this environment variable, refer to the Google Cloud documentation. OAuth 2.0 credentials file: Authentication (OAuth) using the credentials supplied in the service account key file (CREDENTIALS FILE). For more information about creating the service account key file, refer to the Google Cloud documentation.	GCloud_Authentication_Method
CREDENTIALS FILE	Directory path for the service account key file (JSON) used in OAuth 2.0 protocol based authentication. This field is enabled only when the AUTHENTICATION METHOD is set to OAuth 2.0 credentials file.	GCloud_OAuth_File
SERVICE ACCOUNT EMAIL	Service account email for connecting HVR to the Google BigQuery server.	GCloud_Email

Advanced Settings

Field	Description	Equivalent Location Property
LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH	Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib.	ODBC_DM_Lib_Path
LINUX / UNIX ODBCSYSINI	Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc. The odbcinst.ini file should contain information about the BigQuery ODBC Driver under the heading [Simba ODBC Driver for Google BigQuery 64-bit].	ODBC_Sysini
ODBC Driver	Name of the user defined (installed) ODBC driver used for connecting HVR to the Google BigQuery server. For Windows, this is Simba ODBC Driver for Google BigQuery. For Linux, this is Simba ODBC Driver for Google BigQuery 64-bit.	ODBC_Driver

Field

Description

Equivalent Location Property

LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH

Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system.

For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib.

ODBC_DM_Lib_Path

LINUX / UNIX ODBCSYSINI

Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system.

For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc.

The odbcinst.ini file should contain information about the BigQuery ODBC Driver under the heading [Simba ODBC Driver for Google BigQuery 64-bit].

ODBC_Sysini

ODBC Driver

Name of the user defined (installed) ODBC driver used for connecting HVR to the Google BigQuery server.

For Windows, this is Simba ODBC Driver for Google BigQuery.

For Linux, this is Simba ODBC Driver for Google BigQuery 64-bit.

ODBC_Driver

Staging

HVR supports staging for Google BigQuery location. For information about the location properties for staging, see Staging for BigQuery.