Skip to main content

BigQuery Integration

How to integrate BigQuery with Hook

Updated over a month ago

BigQuery Integration

To be able to set up an integration within Hook:

  • The individual setting up the integration must be a user within the platform - please contact your team to set you up with user access.

  • There should be an integration user set up for BigQuery with the correct permissions. You will need to have Owner or Editor permissions (or the Service Account Admin role) in your Google Cloud Platform (GCP) project to complete the steps below.

Follow to the Integrations page (https://app.hook.co/configuration/integrations) in the Hook UI. You would be able to see a screen like below, press the ‘+ Add integration’ button.

Select the BigQuery integration from the list.

You will then need to enter the credentials in the image below and then click ‘Submit credentials’.

  • Service Account: The email address of the service account you create in GCP (format is [email protected])

  • Project ID: Your GCP project identifier (find this in your GCP console).

  • Private Key ID: A unique identifier for the key (this comes from the JSON file you download).

  • Private Key: The actual secret key used for authentication (from the JSON file - starts with -----BEGIN PRIVATE KEY-----)

  • Client Email: Same as Service Account (also in the JSON file)

  • Client ID: A numeric identifier for the service account (in the JSON file)

  • Datasets: Which BigQuery datasets Hook should have access to

  • Client x509 Cert URL: URL that points to the public certificates for your service account. URL is in the format https://www.googleapis.com/robot/v1/metadata/x509/{YOUR-SERVICE-ACCOUNT-EMAIL} (This comes from the JSON file you download).

You do not need to edit the following fields as they are already populated by Hook:

  • Auth URI

  • Token URI

  • Auth Provider x509 Cert URL

  • Universe Domain

How to get this information from GCP:

Detailed instructions can be found in Google's Create access credentials guide.

  1. Go to Google Cloud Console → IAM & Admin → Service Accounts.

  2. Create a new service account (or use an existing one).

  3. Grant the service account the BigQuery Data User role.

  4. Create a JSON key for that service account.

  5. Download the JSON file - it contains most of the fields you'll need.

  6. Copy the values from the JSON into this form:

Please note: the sign in here is the integration user you will set up for Hook. This user must have the correct permissions for Hook to access the tables needed (Owner permissions, Editor permissions or Service Account Admin role).

The final step is to inform the Hook team once you have set up the connection to BigQuery.

Did this answer your question?