Establish Connectivity to Google BigQuery

This article details how to establish connectivity to Google BigQuery plugin.  

PREREQUISITES:

1. Create New Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+New Data Source];
  2. Choose "Google BigQuery" in the Plugin drop-down list;
  3. [Next];
  4. Data Source Name: Give the Data Source a descriptive name;
  5. [Crate].

2. Specify Required Parameters

  1. Auth Type: Select how the authorization of a client will proceed:
    • "Service account key": proceed to Configure Optional Parameters section to provide a service account key;
    • "OAuth": requires Client ID and Client Secret for token generation;

Note: If Data Source utilizes service account key authorization, only objects from the according service account's parent project can be used.

  1. Client ID: Provide Google services Client ID;
  2. Client Secret: Provide the Client Secret;
  3. [Get Token]

Next, you will be asked to enter Google account information in the dialog that opens. The following dialog will ask you for permissions to view and manage BiqQuery data.

Optionally, toggle on Enable On-Demand Element Creation

3. Configure Optional Parameters

Scroll the page to find the Optional Google BigQuery Parameters section.

Destination Dataset and Destination Table parameters work only with service account key authorization and need to be specified only for large queries.


Name Description
1 Destination Dataset Enter a Destination Dataset for large queries processing.
2 Destination Table Enter a Destination Table for large queries processing.
3 Object types to collect List object types to be returned, separated with comma.
4 Service account key Upload a service account key:
  • Can be found in Google Cloud Console. Select a Project > Navigation Menu > IAM & Admin > Service Accounts > select a Service Account > Keys tab;
  • Only a JSON key can be used.
5 Use Legacy SQL Specify if you want to be using Legacy SQL (non-standard variant of SQL used within Google)
  • Obsolete parameter

4. Proceed with Advanced Configuration

Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.

  1. If Data Sources utilizes service account key authorization, you can use a Proxy;
  2. [Test Connection] in the upper right corner.