Configuration

On the Configuration tab you can specify information to connect to Google BigQuery.

The Google BigQuery configuration utilizes the BigQueryConnectionResource to retrieve the table schema information. The connection shared resource is configured on the Configuration page.

BigQueryConnectionResource utilizes bigquery configuration to retrieve table schema information

Note: The BigQuery connection created in the shared module is not set to default when Google BigQuery plug-in activities are created in the application module. You must manually select the Google BigQuery connection from the shared module.
The Configuration page consists of four sections:
  • General
  • Configuration
  • Authentication
  • Service Account Key Authentication

General

In the General section, you can specify the package where the shared resource is stored in the Package field and provide a short description for this shared resource in the Description field. The panel also shows the shared resource name defined when creating the shared resource.

Configuration

In the Configuration section, you can specify the Project ID field and provide a Dataset Name from this project.

Authentication Type

In the Authentication Type section, you can select the type of authentication. The current available authentication is Service Account Key.

Service Account Key Authentication

In the Service Account Key Authentication section, you can specify the JSON File Path for authenticating the Service Account Key.

The descriptions of the fields in the above tabs is as follows:

Shared Resource > Configuration Page > General Fields
Field Module Poperty? Description
Package No The name of the package where the shared resource is added.
Name No The name to be displayed as the label for the shared resource in the process.
Description No A short description for the shared resource.
Shared Resource > Configuration Page > Configuration Fields
Field Module Poperty? Description
Project ID Yes Name of the project from which Google BigQuery is referred.
Dataset Name Yes Name of the Dataset from project selected above.
Shared Resource > Configuration Page > Authentication Fields
Field Module Poperty? Description
Authentication Type No The type of authentication used for connecting to Google BigQuery. Currently used is Service Account Key
Shared Resource > Configuration Page > Service Account Key Authentication Fields
Field Module Poperty? Description
JSON File path Yes Absolute or relative path of the JSON file containing the Service Account Key.