> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# BigQuery

> Access Token Terminal datasets directly in Google BigQuery.

## Overview

To access data from our datasets on [BigQuery](https://cloud.google.com/bigquery), you'll need a Google Cloud Platform (GCP) account and an invitation from our team. If you haven't been in touch with us yet, please reach out to us at [sales@tokenterminal.xyz](mailto:sales@tokenterminal.xyz) to request access.

Once you've signed up and received access, navigate to BigQuery, where you'll find the SQL interface. Below, we've provided a detailed, step-by-step guide to help you access our datasets.

## Video Walkthrough

<iframe className="w-full aspect-video rounded-xl" src="https://www.youtube.com/embed/5Ac6ryz5hEs" title="YouTube video player" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />

## Steps for adding a Token Terminal dataset in BigQuery

1. Navigate to [console.cloud.google.com/bigquery](https://console.cloud.google.com/bigquery)
2. Click on "ADD".

<img src="https://mintcdn.com/tokenterminal/OSOuTfyc-ixmyoWE/images/bigquery-add-1.png?fit=max&auto=format&n=OSOuTfyc-ixmyoWE&q=85&s=1d521d229d6416b2f8f7e6c58e5b3b4e" alt="Add project in B" width="1410" height="792" data-path="images/bigquery-add-1.png" />

3. Click on "Star a project by name".

<img src="https://mintcdn.com/tokenterminal/OSOuTfyc-ixmyoWE/images/bigquery-star-2.png?fit=max&auto=format&n=OSOuTfyc-ixmyoWE&q=85&s=0a0ea448f5cab44501a3ff967dca3c97" alt="Star a project by name in BigQuery" width="1412" height="802" data-path="images/bigquery-star-2.png" />

4. Insert the project (data table) name. The four project names are

* `tt-contracts`
* `tt-blockchain`
* `tt-abstractions`
* `tt-prices`

<img src="https://mintcdn.com/tokenterminal/OSOuTfyc-ixmyoWE/images/bigquery-project-3.png?fit=max&auto=format&n=OSOuTfyc-ixmyoWE&q=85&s=33e73fc04a95c5c7ac15a90bb2504979" alt="Insert project name in BigQuery" width="1410" height="806" data-path="images/bigquery-project-3.png" />

<Card title="BigQuery Syntax Guide" icon="google" href="https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax">
  Check out the official BigQuery syntax guide for more information on how to use the platform's SQL implementation.
</Card>