---
schema_version: "1"
id: 3d97c862ef2a88686c2d997385423537284bdce0b06d7194bcb15bc01f4892e2
title: Gain Insights on 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_for_googlebigquery.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_for_googlebigquery.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 94869525cf50c0990a13fc8a41da54a0a8573517d1945cc5c3fd8c6eadca8e0c
description: You can explore your data in a Google BigQuery data warehouse without loading data into CRM Analytics or preparing it in datasets. CRM Analytics Direct Data for Google BigQuery lets you set up a live connection to the BigQuery schema you want to explore. You can run queries on the schema associated with the connection in real time. You can also build dashboard charts and tables based on the queries you run on BigQuery data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Gain Insights on Data Directly in Google BigQuery

You can explore your data in a Google BigQuery data warehouse without loading data into CRM Analytics or preparing it in datasets. CRM Analytics Direct Data for Google BigQuery lets you set up a live connection to the BigQuery schema you want to explore. You can run queries on the schema associated with the connection in real time. You can also build dashboard charts and tables based on the queries you run on BigQuery data.

- **[When to Use CRM Analytics Direct Data for Google BigQuery](https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_bigquery_when_to_use.htm&release=264.0.0&type=5)**  
    To run analysis on your Google BigQuery data, you can use CRM Analytics Direct Data for Google BigQuery or Google BigQuery input connectors or a combination of the two.
- **[CRM Analytics Direct Data for Google BigQuery Tips and Considerations](https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_bigquery_tips_considerations.htm&release=264.0.0&type=5)**  
    It helps to be familiar with these tips and considerations when working with Direct Data for Google BigQuery.
- **[Create a Live Connection to Google BigQuery](https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_bigquery_create_connection.htm&release=264.0.0&type=5)**  
    Create a live connection to Google BigQuery warehouse to explore your data stored there.
- **[Explore Data Directly in Google BigQuery](https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_bigquery.htm&release=264.0.0&type=5)**  
    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.