Connecting Looker to Hevo

Refer to this section to connect Looker to your managed BigQuery data warehouse.

Prerequisites

  • An active Looker account.
  • Looker connection settings downloaded from Hevo.

Steps

  1. In your Looker account, navigate to Admin section, and scroll down to Database in the left navigation pane.

  2. Click Connections, and then, New Connection.

  3. In the New Connection page, specify the following mandatory settings:

    1. Name: A name for your database.

    2. Dialect: Select Google BigQuery Standard SQL (Recommended) or Google BigQuery Legacy SQL.

    3. Project Name: The Project ID mentioned in the connection settings downloaded from Hevo..

    4. Dataset: The Dataset ID mentioned in the connection settings downloaded from Hevo..

    5. Use OAuth: Deselect this check box.

    6. Service Account Email: The service account ID mentioned in the connection settings downloaded from Hevo. For example, testserviceaccounteditor@testproject-286015.iam.gserviceaccount.com

    7. Service Account JSON/P12 File: Upload the JSON file with the connection credentials, downloaded from Hevo.

    8. Password: Leave this field empty.

    9. Temp Dataset: The Temporary Dataset ID mentioned in the connection settings downloaded from Hevo.

    10. Max Billing Gigabytes: Use the default value.

    11. Max Connections: Use the default value.

    12. Connection Pool Timeout: Use the default value.

    13. SQL Runner Precache: If you don’t want SQL runner to preload information in your tables, you can deselect this option.

    14. Database Time Zone: The Dataset Timezone from the connection settings provided by Hevo.

  4. Click Update Connection to connect Looker to the managed BigQuery data warehouse. The connection details are displayed. Click Test These Settings to test the connection.

Last updated on 06 Oct 2020