Manage the BigQuery Connector

The Composer BigQuery connector lets you access the data available in Google BigQuery storage using the Composer client. The Composer BigQuery connector supports the current version of this software as a microservice (SaaS) product.

Composer does not provide an out-of-the-box BigQuery connection. You must first download, install, configure, and enable it to connect to it in Composer. For steps and more information, see the Google BigQuery website. Also see Manage Connectors and Connector Servers for general instructions and Connect to BigQuery for details specific to the BigQuery connector.

After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create Dashboards.

Composer Feature Support

BigQuery connector support for specific Composer features is shown in the following table.

Key: P - Supported; O - Not Supported; N/A - not applicable

Feature Supported?
Admin-Defined Functions P
Box Plots P
Custom SQL Queries O
Derived Fields (Row-Level Expressions) P
Distinct Counts P
Fast Distinct Values N/A
Group By Multiple Fields P
Group By Time P
Group By UNIX Time P
Histogram Floating Point Values P
Histograms P
Kerberos Authentication N/A
Last Value P
Live Mode and Playback P
Multivalued Fields N/A
Nested Fields N/A
Partitions P
Pushdown Joins for Fusion Data Sources P
Schemas P
Text Search N/A
User Delegation O
Wild Card Filters P
Wild Card Filters, Case-Insensitive Mode P
Wild Card Filters, Case-Sensitive Mode P

Connect to BigQuery

When connecting to BigQuery, provide the following information:

  • Key Path: you have to specify the absolute path to the file that must be available for the connector.
  • Public Project IDs.

For more information about these values, refer to Google BigQuery's documentation.

Authorize the BigQuery Connection

To authorize the BigQuery connection, you need to create a security key for it. Before you can create the security key, you must access or create a BigQuery microservice account.

To create a BigQuery microservice account, perform the following steps:

  1. Login to your Google API Console.

  2. Select the required project from the list.

  3. Make sure that current account is linked to a billing account. To check this, select the icon and then select Billing.

  4. On the API Manager page, select Credentials:

  5. On the Credentials page, select Manage service accounts.

  6. On the Service Accounts page, select Create Service Account and specify the following:

    • Service account name
    • Role - grant this microservice account role based access to the project. From the list, select the BigQuery category and then select BigQuery Data Viewer and BigQuery User roles.
    • Service account ID

  7. Select Create.

After you have created an account, create a security key for it.

To create a security key:

  1. On the Service Accounts page, find the required account.

  2. From the menu, select Create key.

  3. In the Create private key dialog, select JSON for the key type and select Create. The local copy of the key is saved on your computer.

    For more information, see the following Google resources: BigQuery Introduction to Authentication and Using OAuth 2.0 for Server to Server Applications.

  4. Move the file with the key to the server, on which the connector is running.