Accessing BigQuery directly

This page describes how to configure direct access to your Drivepoint-managed BigQuery data warehouse.

Note: Access to this feature requires a subcription to the Advanced Analytics Add-On. Please contact your customer success manager for more information.

Overview

The easiest way to configure access to your Drivepoint data warehouse is via a google group (or any email group on their side). This has a few advantages which are:

• Customers can provision or de-provision the users in their organization without needing to contact Drivepoint support

• Onboarding / Offboarding from a Drivepoint perspective is easy as we simply have to add/remove the group and not individual users

Step 1 - Create a Google group alias and add users

1. Go to groups.google.com and follow the instructions for creating a new group

2. Give your group with a descriptive name/address, something like [e-mail]

3. Add any users from your organization to the group. All the users you add to the group will be granted access to your BigQuery instance.

Step 2 - Provide your Drivepoint CSM with the fully qualified email address for that group.

1. Provide that group name to your Drivepoint CSM

2. Once access has been provisioned, we'll reach out with confirmation and provide you with a unique URL to access the BigQuery resources.

Step 3 - Verify Access

1. Visit the URL provided by your Drivepoint CSM in the previous step.

2. Run a test query to confirm you have correct data access and permisions to access and query the data

That's it! You can now work with your BigQuery data:

• directly in the BigQuery UI

• in a connected Google sheet

• in a 3rd party BI tool like Looker or Looker Studio, or

• via any third party SQL editor that supports BigQuery as a datasource

Happy analyzing!