Warehouse Guide: BigQuery

Create a Google Cloud project and a service account key, then connect BigQuery as your data warehouse.

• Connector type Warehouse
• Auth method Service account JSON key

Before you start

• A Google Cloud project linked to a billing account — BigQuery features are disabled without one

Set up BigQuery as your warehouse

1. Provision your BigQuery warehouse

   1. In the Google Cloud Console, click Create Project.
   2. Select the Organization and provide a suitable Project Name, Project ID and Location.
   3. Link the project to the correct billing account to avoid service interruptions.

2. Configure access for Kleene

   1. Log in to the Google Cloud Console.
   2. Go to IAM & Admin, then 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 Service Accounts page, find the new service account, click the menu under Actions, and click Manage keys.
   6. Click Add Key → Create new key.
   7. Select the JSON key type and click Create. A JSON key file downloads to your system.

3. Add the warehouse in Kleene

   • JSON key fileDrag and drop the downloaded file into the warehouse configuration panel, then fill in any fields that remain and click Save

   Kleene can now load data into your warehouse.

Good to know