How to connect Houseware to BigQuery

Learn how to connect your BigQuery Data Warehouse to Houseware.

Overview

This step-by-step guide will enable the Houseware application to access your events data for product analytics. To maintain separation of concern, we suggest you create a separate BigQuery dataset containing your events and share its access with our application.


Step-by-Step Guide

Step 1: Get Houseware's Google Cloud Platform service account

Houseware will create a service account for your organization and provide you with a service account email, typically in the format of <YOUR_ORG>-serviceaccount@xyz.iam.gserviceaccount.com.

Step 2: Grant required permissions to the service account

To allow Houseware to read and process data from BigQuery, the service account will need the following roles granted to it:

1. BigQuery Job User role

Grant this role to allow the Houseware application to run jobs on BigQuery. This will allow the Houseware application to run SQL on your BigQuery. Follow the steps below to grant this role.

πŸ“˜

Note: Granting this permission requires access to the IAM console. You may need to contact your data/infra team to get these permissions.


2. BigQuery Data Viewer and Editor roles

Grant both roles to the Houseware service account so that the Houseware application can read your events data and write internal metadata tables in your events dataset.

The Houseware service account requires the BigQuery Data Editor and BigQuery Data Viewer roles. You can follow the below Arcade for reference on how to grant these permissions.


That's it! πŸŽ‰ Houseware will now configure your connection and spin up an instance for your organization to do your analysis.