Setting up a BigQuery Warehouse

Create a Project

To create a Project in BigQuery, navigate to the Google Cloud Console and click on
‘Create Project’:

Select the Organization and provide a suitable Project Name, Project ID and Location. Ensure that the project is linked to the correct billing account to avoid service interruptions.

❗️

Please ensure that your project is associated with a billing account to enable all BigQuery features

Create a Service Account

1. Log in to the Google Cloud Console.
2. Go to the IAM & Admin page, then click Service Accounts > + Create Service Account.

3. In the Service account details step, enter values in the fields, then click Create and Continue.
4. Skip the optional sections and click Done.
5. On the Services Accounts page, find the newly created service account, click the menu under Actions, and click Manage keys.

6. Click Add Key > Create new key.
7. Select the JSON key type, then click Create. A JSON key file downloads to your system.

🚧

NOTE: After you download the key file, you cannot download it again.

Share Keys

Share the JSON file to your customer 1Password Vault. A BigQuery template should be provided so that you may simply upload the details securely into the vault.

Setup BigQuery Data Warehouse in Kleene App

1. Select the Google Big Query data warehouse option.
2. Drag and drop the JSON file into Kleene warehouse configuration panel.
3. Add correct values to any fields that remain.
4. Click Save.