Google BigQuery

Google BigQuery

Fully managed serverless data warehouse for large-scale analytics, SQL queries, streaming inserts, and BigQuery ML.

OAuth47 tools

Three ways to use Google BigQuery

Chat with Geni

Ask Geni to pull data, take actions, or answer questions using this integration in a conversation.

Build a workflow

Create automated workflows that trigger on events, run on a schedule, or chain multiple tools together.

Power an app

Use this integration as a data source or action layer behind a dashboard, form, or internal tool.

Supported tools

Actions your AI agents can perform with Google BigQuery.

Batch Delete Row Access Policies

Delete all listed row access policies on a table in one call.

Tool

Cancel Job

Request cancellation of a running BigQuery job. Returns immediately — poll Get Job to confirm.

Tool

Create Dataset

Create a new BigQuery dataset in a specific location. Location is required and cannot be changed later.

Tool

Create Routine

Create a routine: scalar UDF, aggregate function, table-valued function, or stored procedure.

Tool

Create Row Access Policy

Create a row-level security policy on a table with a SQL filter predicate and grantee list.

Tool

Create Table

Create a standard, external, view, or materialized-view table. Supports time/range partitioning and clustering.

Tool

Get started automating Google BigQuery

01Connect your accountLink your account securely with OAuth or an API key.
02Choose a trigger or toolPick the events and actions your workflow should use.
03Configure the workflowDescribe what you want and Geni wires it up for you.
04Refine the processTest runs, review output, and tweak until it's right.
05Turn it onSet it live and it runs on a schedule or on events.

Ready-to-use workflows

Prompts using Google BigQuery

Browse all

Morning data freshness board for your BigQuery tables

One grid of every table you track, when it last landed, and what broke, with stale tables pinned to the top and an agent that explains why.

Google BigQueryLinearSlack Bot

BigQuery cost console with team budgets and query fixes

See month to date BigQuery spend by team, by person, and by label against the budgets finance keeps, then fix the queries driving it.

Google BigQueryGoogle SheetsSlack Bot

Push BigQuery audience segments into HubSpot with review

A library of saved audience definitions your growth team can run, review, and push into HubSpot, with nothing written until someone clicks push.

Google BigQueryHubSpotSlack Bot

Ask your BigQuery warehouse questions in plain English

A read only query console where anyone asks a question, sees the query and what it will cost, and nothing runs until a person clicks Run.

Google BigQueryGroqSlack Bot

Weekly BigQuery cost review with Slack digest and Linear tickets

Every Monday, find out which queries are driving your BigQuery bill, get a ranked cost summary in Slack, and turn the worst offenders into tickets.

Google BigQuerySlackLinear

Weekday morning business metrics anomaly digest in Slack

Every weekday at 8am, get a plain-English Slack digest of your key business metrics with the biggest anomalies called out first.

Google BigQuerySlack

Hourly Shopify orders sync to BigQuery

Every hour, stream new Shopify orders into a BigQuery table so your warehouse always has fresh sales data your analysts can query.

ShopifyGoogle BigQuery

Nightly BigQuery to HubSpot contact score sync

Push warehouse-computed engagement scores, churn risk, LTV, and top feature into HubSpot contacts every night, keyed by email.

Google BigQueryHubSpot
+1Browse all prompts