BigQuery
With Querier, you can integrate with BigQuery and execute various queries.
Preparation
First, follow these steps to obtain a GCP service account:
- Log in to the GCP console.
- Click [IAM & Admin].
- Click [Service Accounts].
- Click [Create Service Account].
- Enter a [Service Account Name].
- Choose permissions from [Select a role].
- Click [Done].
- Click [Actions] on the created service account.
- Click [Manage keys].
- Click [Add Key], then [Create new key].
- Open and copy the downloaded JSON key.
Connection Method
1. Create a new data source connection
- Click the [Resources] tab.
- Click the [Create] button next to [Resources].
- Select [BigQuery].
2. Enter the connection information
Field | Description |
---|---|
Name | Enter the name for the BigQuery connection. |
Project ID | Enter the Project ID related to the BigQuery you are connecting to. |
Credentials JSON | Enter the service account JSON for the BigQuery connection. |
Location | Enter the location for BigQuery (e.g., us , asia-northeast1 ). |