Table of Contents

CaliberMind Data Warehouse Access in Google BigQuery

CaliberMind Data Warehouse Access in Google BigQuery

In this article we will cover why administrators would want to set up data warehouse access in BigQuery for CaliberMind users, who they might give access to, and how to set up access for existing CaliberMind users as well as new users.

Why Utilize the Data Warehouse in CaliberMind

CaliberMind Admins may want to give engineers, data scientists, analysts, or marketing operations access to the organization's data in the data warehouse at BigQuery for the purposes of:

  • Running SQL Queries
  • Exporting Lists
  • Analyzing Data
  • Quality Assurance
  • Data Integrity
  • Troubleshooting

Setting up Data Warehouse access for Existing CaliberMind users

  1. Go to the Settings Cog on the top right of the menu bar.
  2. Click the Account drop down list in the left menu rail
  3. Select Data Warehouse Access
  4. The Data Warehouse Access Edit screen will appear.

CaliberMind Data Warehouse Access settings

Click on the drop-down that says ‘Select from existing users’

Selecting from existing users who to provide access to your BigQuery Data Warehouse

Select the name of the user from your organization that you wish to give Google BigQuery Data Warehouse access.

Managing the Users that can Access Your CaliberMind BigQuery Data Warehouse

You will see the user's email address populate in the field to the right, confirm this is correct, and click the Blue ‘ADD USER’ Button.

Click on the Add User button to grant access to CaliberMind Data Warehouse access in BigQuery

That user will now be given Google BigQuery Data Warehouse access and you will see their email populated in the list of users that have access to the data warehouse.

CaliberMind displays the list of users that have access to the data warehouse

Setting Up Data Warehouse Access for Non-CaliberMind Users

In CaliberMind you will find the Data Warehouse Access setting at: https://my.calibermind.com/settings/account/dw

(note this link ONLY FUNCTIONS if you have logged into your CaliberMind Application.)

In CaliberMind, head to the Data Warehouse Access setting

Enter the user's email address in the box that says ‘Enter an Email’ and click on the Blue ‘ADD USER’ Button.

Input the email address of the non CaliberMind user and click on the Add User button

That user will now be given Google BigQuery Data Warehouse access and you will see their email populated in the list of users that have access to the data warehouse.

User will be granted BigQuery Data Warehouse access

Removing Data Warehouse Access from a User

In CaliberMind you will find the Data Warehouse Access setting at: CaliberMind Data Warehouse Access

(note this link ONLY FUNCTIONS if you have logged into your CaliberMind Application.)

The list of users that have access to the Data Warehouse will be populated on this screen.

CaliberMind displays list of users with access to the Data Warehouse

To revoke access from a user, find their name in the list and click on the REMOVE button to the right under the Actions menu.

Under the CaliberMind Actions menu, click on the Remove button to revoke access from a user

The user's access to the CaliberMind data warehouse will now be revoked.

How did we do?

User Authentication and Provisioning

Contact