Documentation
Data sources
Connect Databses
BigQuery

BigQuery

With Querier, you can integrate with BigQuery and execute various queries.

Preparation

First, follow these steps to obtain a GCP service account:

  1. Log in to the GCP console.
  2. Click [IAM & Admin].
  3. Click [Service Accounts].
  4. Click [Create Service Account].
  5. Enter a [Service Account Name].
  6. Choose permissions from [Select a role].
  7. Click [Done].
  8. Click [Actions] on the created service account.
  9. Click [Manage keys].
  10. Click [Add Key], then [Create new key].
  11. Open and copy the downloaded JSON key.

Connection Method

1. Create a new data source connection

  1. Click the [Resources] tab.
  2. Click the [Create] button next to [Resources].
  3. Select [BigQuery].

2. Enter the connection information

FieldDescription
NameEnter the name for the BigQuery connection.
Project IDEnter the Project ID related to the BigQuery you are connecting to.
Credentials JSONEnter the service account JSON for the BigQuery connection.
LocationEnter the location for BigQuery (e.g., us, asia-northeast1).