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.
Updated 4 months ago