​
Example

The following agent can query and analyze BigQuery datasets: 
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

ParameterTypeDefaultDescription
datasetstrNoneBigQuery dataset name (required).
projectOptional[str]NoneGoogle Cloud project ID. Uses GOOGLE_CLOUD_PROJECT.
locationOptional[str]NoneBigQuery location. Uses GOOGLE_CLOUD_LOCATION.
credentialsOptional[Any]NoneGoogle Cloud credentials object.
enable_list_tablesboolTrueEnable table listing functionality.
enable_describe_tableboolTrueEnable table description functionality.
enable_run_sql_queryboolTrueEnable SQL query execution functionality.

​
Toolkit Functions

FunctionDescription
list_tablesList all tables in the specified BigQuery dataset.
describe_tableGet detailed schema information about a specific table.
run_sql_queryExecute SQL queries on BigQuery datasets.

​
Developer Resources