Wiki Admin

Location Connection for Google BigQuery - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Location Connection for Google BigQuery - DSS 6 | Data Source Solutions Documentation

Location Connection for Google BigQuery

This section lists and describes the connection parameters required for creating Google BigQuery location in Data Source Solutions DSS. 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 DSS 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 DSS 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 DSS 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

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