Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.hyperfx.ai/llms.txt

Use this file to discover all available pages before exploring further.

The BigQuery integration lets your agents and workflows query and write to your Google BigQuery data warehouse using SQL. Auth type: OAuth (via Pipedream Connect)
For how integrations work overall (permissions, authentication, troubleshooting), see the main guide: App Integrations.

​
Connect BigQuery

  1. Go to Settings → Apps in Hyper
  2. Select BigQuery → Connect New
  3. Authorize access to the Google Cloud project that contains your BigQuery datasets
The connection grants Hyper read/write access to the datasets you authorize. You can connect multiple BigQuery projects.

​
Common capabilities

  • Run SQL queries against any dataset and table you have access to
  • Insert rows into existing tables
  • Pull data into agents for analysis, reporting, and dashboards

​
Use in Chat

  1. In a chat, open the tool selector and enable BigQuery
  2. Ask your agent to query your warehouse and analyze the results
Example prompt: 
Query our `analytics.events` table for the last 30 days. Group by event_name and return the top 10 most-common events with their counts. Then summarize what changed compared to the previous 30 days.

​
Use in Agents

In Agents → Settings, add BigQuery to the agent’s toolkits and select the connection. Toggle which actions require approval (e.g., “insert rows”).

​
Use in Flows

Add a BigQuery action node to query or insert data, and pass the results to downstream nodes (Slack alerts, Google Sheets exports, etc.).

​
Troubleshooting

  • Permission denied: ensure the Google account you authorized has access to the dataset and the BigQuery Data Viewer / BigQuery User roles as needed
  • Quota exceeded: BigQuery enforces per-project quotas — check your Google Cloud Console