> ## Documentation Index
> Fetch the complete documentation index at: https://phidatainc-studio-tools-doc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Google BigQuery

> GoogleBigQueryTools enables agents to interact with Google BigQuery for large-scale data analysis and SQL queries.

## Example

The following agent can query and analyze BigQuery datasets:

```python theme={null}
from agno.agent import Agent
from agno.tools.google_bigquery import GoogleBigQueryTools

agent = Agent(
    instructions=[
        "You are a data analyst assistant that helps with BigQuery operations",
        "Execute SQL queries to analyze large datasets",
        "Provide insights and summaries of query results",
        "Help with data exploration and table analysis",
    ],
    tools=[GoogleBigQueryTools(dataset="your_dataset_name")],
)

agent.print_response("List all tables in the dataset and describe the sales table", stream=True)
```

## Toolkit Params

| Parameter               | Type            | Default | Description                                           |
| ----------------------- | --------------- | ------- | ----------------------------------------------------- |
| `dataset`               | `str`           | `None`  | BigQuery dataset name (required).                     |
| `project`               | `Optional[str]` | `None`  | Google Cloud project ID. Uses GOOGLE\_CLOUD\_PROJECT. |
| `location`              | `Optional[str]` | `None`  | BigQuery location. Uses GOOGLE\_CLOUD\_LOCATION.      |
| `credentials`           | `Optional[Any]` | `None`  | Google Cloud credentials object.                      |
| `enable_list_tables`    | `bool`          | `True`  | Enable table listing functionality.                   |
| `enable_describe_table` | `bool`          | `True`  | Enable table description functionality.               |
| `enable_run_sql_query`  | `bool`          | `True`  | Enable SQL query execution functionality.             |

## Toolkit Functions

| Function         | Description                                             |
| ---------------- | ------------------------------------------------------- |
| `list_tables`    | List all tables in the specified BigQuery dataset.      |
| `describe_table` | Get detailed schema information about a specific table. |
| `run_sql_query`  | Execute SQL queries on BigQuery datasets.               |

## Developer Resources

* View [Tools Source](https://github.com/agno-agi/agno/blob/main/libs/agno/agno/tools/google_bigquery.py)
* [BigQuery Documentation](https://cloud.google.com/bigquery/docs)
* [BigQuery SQL Reference](https://cloud.google.com/bigquery/docs/reference/standard-sql/)