Google BigQuery

What is the Google BigQuery tool?

The Google BigQuery tool is a built-in capability in the Agno framework that allows AI agents to query google bigquery datasets. When added to an agent in Agno Builder, the agent can autonomously decide when to invoke this tool based on the user's request.

This tool requires a GOOGLE_CLOUD_PROJECT environment variable. Get your API key at console.cloud.google.com.

How to use Google BigQuery in Agno Builder

1. 1

   Create an agent

   Drag an Agent node onto the canvas in Agno Builder, or use one of the built-in templates.

2. 2

   Enable Google BigQuery

   Click the agent, go to the Tools tab, and toggle on "Google BigQuery" from the data category.

3. 3

   Add your API key

   Enter your GOOGLE_CLOUD_PROJECT in the tool configuration. Your key stays in your browser and is never stored on our servers.

4. 4

   Test in chat

   Open the chat panel and send a message. The agent will automatically use Google BigQuery when relevant.

5. 5

   Export Python code

   Click File > Export Python to get clean, runnable code with the correct imports for Google BigQuery.

Python code example

This is the code Agno Builder exports when you use Google BigQuery:

from agno.agent import Agent
from agno.models.openai import OpenAIChat
from agno.tools.google_bigquery import GoogleBigQueryTools

agent = Agent(
    name="Google BigQuery Agent",
    model=OpenAIChat(id="gpt-4o"),
    tools=[GoogleBigQueryTools()],
    instructions=["Use the google bigquery tool to help the user."],
    markdown=True,
)

agent.print_response("Help me with a bigquery task")

Install with: pip install agno # + set GOOGLE_CLOUD_PROJECT