Skip to main content

Documentation Index

Fetch the complete documentation index at: https://hyperfx.ai/docs/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

​
Available Actions

Hyper agents can run the following actions for this integration. Each action can be individually set to Enabled, Requires Approval, or Disabled in your agent’s toolkit settings. Actions can be set to one of three control states:
StateBehavior
EnabledAgent runs the action automatically
Requires ApprovalAgent pauses and waits for your confirmation before proceeding
DisabledAction is blocked and cannot be used
Configure these in the agent’s toolkit settings or in workspace defaults.
ActionDescription
Execute QueryExecute a SQL query in Google BigQuery and return the results. Supports both standard SQL and legacy SQL syntax
Insert RowsInsert rows of data into a Google BigQuery table. Supports batch inserts with error handling