---
schema_version: "1"
id: d68cbd8ed01de79e5a2bd35caa43f7d2ee92b85efa8e9af677a26987509ba876
title: Explore Data Directly in Google BigQuery
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_direct_data_bigquery.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_bigquery.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f45136dc6c65255625a83b5e31af9f6e0cfa1ca7cef1cd40a8b8536bb7ab0c90
description: After you complete setup, CRM Analytics Direct Data for Google BigQuery lets you run queries on the dataset associated with the connection in real time. You can also build dashboard charts and tables based on the queries you run on Google BigQuery data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Explore Data Directly in Google BigQuery

After you complete setup, CRM Analytics Direct Data for Google BigQuery lets you run queries on the dataset associated with the connection in real time. You can also build dashboard charts and tables based on the queries you run on Google BigQuery data.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d74281e34">User Permissions Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d74281e34 ">To create live connections to Google BigQuery:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d74281e34 ">Enable CRM Analytics Direct Data for external data sources</td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d74281e34 ">To explore data directly in Google BigQuery:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d74281e34 ">Explore External Data Directly</td>

        </tr>
      </tbody>
    </table>

To begin exploring, click the live dataset from the Datasets tab in Analytics Studio.

![Live Data Connections to Google BigQuery in CRM Analytics](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_live_data_list_bigquery.jpg)

Data stored in the Google BigQuery object opens in a lens, which you can interactively explore and visualize.

![Objects in Google Warehouse](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_live_data_list_bigquery_objects.jpg)