# BigQuery

{% hint style="info" %}
**Note:** Access to this feature requires a subcription to the Advanced Analytics Add-On. Please contact your customer success manager for more information.
{% endhint %}

### 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](http://groups.google.com) and follow the instructions for [creating a new group](https://apps.google.com/supportwidget/articlehome?hl=en\&article_url=https%3A%2F%2Fsupport.google.com%2Fa%2Fanswer%2F9400082%3Fhl%3Den\&assistant_id=generic-unu\&product_context=9400082\&product_name=UnuFlow\&trigger_context=a)
2. Give your group with a descriptive name/address, something like `drivepoint-dwh@mycompany.com`
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](https://cloud.google.com/bigquery/docs/bigquery-web-ui#overview)
* in a [connected Google sheet](https://cloud.google.com/bigquery/docs/connected-sheets#use)
* in a 3rd party BI tool like Looker or [Looker Studio](https://support.google.com/looker-studio/answer/6370296?hl=en#zippy=%2Cin-this-article), or
* via any third party SQL editor that supports BigQuery as a datasource

Happy analyzing!


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.drivepoint.io/data-integrations/bigquery.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.