BigQuery
Connecting to BigQuery
To connect to a BigQuery Database, the following information will be necessary:
- Display name : A name of your choice to identify the database.
- Project ID : The ID of your project.
- Dataset (optional): The name of your dataset is optional. If left empty all available datasets will be shown.
- Schema name : (optional) The name of the database schema you want to connect to.
- KeyFile JSON: Paste the entire KeyFile.json into this field.
Creating a Service Account and KeyFile:
![](https://pushmetrics.io/content/images/2021/05/create_service_acc.png)
- Give the Account a name and click "create".
![](https://pushmetrics.io/content/images/2021/05/Screenshot-2021-05-04-at-18.21.44.png)
- As role, the account will need at least the following:
- BigQuery Data Viewer
- BigQuery Job User
Use the search function to add both.
![](https://pushmetrics.io/content/images/2021/05/Screenshot-2021-05-04-at-18.24.22.png)
- Click 'Done'.
- Click the newly added Service Account and Select 'Keys'.
![](https://pushmetrics.io/content/images/2021/05/click_service_acc.png)
- Click 'Add Key', 'Create new key', 'JSON', 'Create'.
![](https://pushmetrics.io/content/images/2021/05/Screenshot-2021-05-04-at-18.27.23.png)
The KeyFile will download automatically and you can now copy and paste its content.