Connecting Looker to Hevo

Last updated on Mar 18, 2024

Starting Release 2.20, the Hevo Managed BigQuery Destination is available only to users who have existing Pipelines with it. If you need to reauthorize or change the Google account in your existing Pipeline, you must contact Hevo Support.

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.

Tell us what went wrong