Google BigQuery

Welcome! This guide will walk you through the process of connecting Google BigQuery to your Usermaven workspace. This integration allows you to seamlessly transfer raw event data, enabling powerful analytics and insights. Follow these steps carefully to ensure a successful setup.

Pre-requisites

Make sure you have:

• An active Google Cloud account
• Permissions to create projects and service accounts in Google Cloud
• Google BigQuery API enabled in your Google Cloud project.
• Access to your Usermaven workspace

Step-by-Step Guide

1. Set Up Your Google Cloud Environment

1. Go to the Google Cloud Console.

2. At the Google Cloud Console welcome page, locate the project selector in the top-left corner. Click on it to reveal a dropdown menu. From there, you have two options:

   • Select an existing project from the list, or
   • Create a new project by clicking the "New Project" button. If creating a new project, enter your desired project name in the provided field, then click the "Create" button to finalize the process.

Choose the option that best suits your needs.

2. Create a Service Account

1. Navigate to the Google Cloud Console and use the search bar to find "Service Accounts". Select "Service Accounts" from the search results.

2. You will then need to create a service account (opens in a new tab). After clicking the Go to Create service account button on the linked docs page, select the project you created and name the service account whatever you would like.

3. Proceed by clicking the Continue button, then assign the necessary roles to allow Usermaven to generate schemas and import data:

   • BigQuery Data Editor
   • BigQuery Job User
   • BigQuery Read Session User

At this stage, it's not necessary to provide user access to the service account. Simply click the Done button to proceed.

3. Download the service account JSON

1. Find your new service account in the list and click on its email address.

2. In the service account details page, look for the "Keys" tab and click on it.

3. Click "Add Key", then "Create new key".

   

4. Make sure JSON is selected, then click "Create".

5. A JSON file will download automatically. Keep this file safe and don't share it publicly.

4. Access Your Usermaven's Integration Settings

Start by logging into your Usermaven account. Go to "Workspace Settings" and locate "Integrations" section in the main menu. Click on it to view available integrations.

5. Locate and Initiate Google BigQuery Integration

Scroll through the integrations until you find the Google BigQuery card. You'll see a "Connect Google BigQuery" button - click on this to start the connection process.

6. Complete the Integration Setup

Now, head back to your Usermaven's integration page:

In the BigQuery integration form, you'll see several fields to fill out:

1. Sync Name: Give this connection a memorable name, like "Daily Events Sync".
2. Start Date: If you want to sync data from a specific date, enter it here. Otherwise, leave it blank to sync all available data.
3. Dataset Name: Enter the name of the BigQuery dataset you want to connect to. This is typically the name of the dataset within your BigQuery project that contains the tables you wish to sync.
4. Refresh Interval: Choose how often you want the data to sync. "1 hour" is a good starting point for most users.
5. Google Service Account: Open the JSON file you downloaded earlier and copy its entire contents. Paste this into the provided field.

Double-check all your entries, then click "Save" to complete the setup.

After saving, you should see your new BigQuery connection listed on the Integrations page. It will show the sync status and when the next sync is scheduled.