Google Cloud BigQuery

Supported version: Cloud.

API Rate Limit: 100 requests per second

Supported Authentication:

OAuth 2.0 Authentication

Application Registration on Google

This document explains the steps to register the application and how to use it on Klera.

Step 1: Register application on Google API Console.

1. Login to the following URL:
    https://console.developers.google.com/apis/credentials

IMPORTANT: You will need additional permissions from the Google Cloud Administrator or from IT department to register an application. Please enable BigQuery API, refer https://support.google.com/googleapi/answer/6158841?hl=en 

2. Go-to ‘Credentials’
3. Click on ‘Create Credentials’
4. Choose ‘OAuth Client ID’
5. On ‘Create OAuth client ID’
    a. Application type: Web Application
    b. Name: Klera
    c. Authorized redirect URIs : Redirect URL of Klera host.
        Ex.: https://HostName-123.Klera.com:48444/AccountManagementWebService/callback.html

Please NOTE that the "HostName-123.klera.com" will be your organization's HostName.domainName for the server where Klera is deployed. Please replace this part with your Klera Server's HostName.domainName in the URL given above and then use it.

IMPORTANT: 1.This URL should be accessible from the client machine from which end-user will access Klera. You may need to create a DNS entry or configure proxy accordingly to make this URL accessible.

2.IMPORTANT: Please make sure your Google Cloud BigQuery instance must be accessible from the Klera Machine.

6. Copy Client ID and Client Secret and keep it safe. We will need this information in
the next step.

Step 2: Import Google Cloud BigQuery Application Template on Klera.

1. Right click on the floor, go to Connectors→ Import.
2. Import the Google Cloud BigQuery Connector.zip file.
3. Right click on the floor, go to Connectors→ Show.
4. Right click on the entity of column “Google Cloud BigQuery Connector” and go to Connectors → Connections → Configure.
        Enter the following details in the form:

        a. Instance URL: https://bigquery.googleapis.com
        b. Application Key: Client ID received from Step 1- #6.
        c. Application Secret: Client Secret received from Step-1 #6.
        d. Authorization URL:
            https://accounts.google.com/o/oauth2/v2/auth?access_type=offline&prompt=consent
        e. Access Token URL: https://oauth2.googleapis.com/token
        f. Domain for Callback Authentication: Enter HostName with Domain Name used in step 1- #5.c
           Example: HostName-123.Kleramachine.com

        g. Scope: openid profile email https://www.googleapis.com/auth/bigquery
           https://www.googleapis.com/auth/cloud-platform                                                                                              https://www.googleapis.com/auth/cloud-platform.read-only
       h. Click on ‘Save’.
       l. On clicking ‘Save’, a pop-up will appear which requires Google
           user to login using the credentials and choose ‘Allow access’ if asked in the
           pop-up window.
       Important: Please make sure, the pop-up is not blocked by the chrome browser.

Step 3: Use Google Cloud BigQuery Application Template

To start the analysis, right-click on the Floor -> Connectors-> Google Cloud BigQuery-> <Operations>

The user will see different operations inside the Google Cloud BigQuery Menu.