How do I connect my warehouse to Gemini?

Connect Rig to Gemini or the Gemini CLI over MCP. Rig builds the context layer over your warehouse and Gemini can then answer with governed SQL.

Does Gemini work well with BigQuery through Rig?

Yes. Rig understands BigQuery datasets and event structures, so Gemini can answer funnel, retention and revenue questions over BigQuery data.

Which warehouses are supported with Gemini?

Snowflake, BigQuery, Redshift, Postgres and DuckDB/MotherDuck, plus SaaS sources synced by Rig Ingest.

AI tools Supported

Google Gemini + Rig

The easiest way to query your warehouse data in Google Gemini

Gemini is Google's AI assistant, available in the Gemini apps and the Gemini CLI, which can connect to external tools and data over MCP.

Try Rig Book a demo

What Rig gives Google Gemini

Once connected, Google Gemini can reason over your governed data through Rig:

Warehouse tables and views
Metric definitions
Join paths
dbt lineage
Role-based access
Sandbox-validated SQL

How Google Gemini connects to Rig

Connect Rig to Gemini over MCP. Gemini can then answer data questions with validated SQL against your governed schema and metric catalog, including data modelled in BigQuery and other warehouses.

Ask warehouse questions in plain English in Gemini

With Rig connected, Gemini turns a question into validated warehouse SQL using your real schema and metric definitions. Teams on Google Cloud can query BigQuery and other warehouses without writing SQL.

Ask Rig

What was customer acquisition cost by channel last month?
Show monthly active users from BigQuery
Which regions grew fastest this quarter?

Keep Gemini's answers grounded and consistent

Rig answers from agreed metric definitions and validates each query before it runs, so Gemini returns the official number rather than a guess. The same question gives the same answer across the team.

Ask Rig

How is active user defined here?
Show the SQL behind that number
Recompute with the official revenue metric

Use the Gemini CLI for data-aware scripting

The Gemini CLI can query your warehouse through Rig as it builds, so scripts and reports run on real, validated data. Read-only access keeps the warehouse safe during exploration.

Ask Rig

Write a script that pulls weekly revenue
Generate the SQL for retention by cohort
Validate and run this query against the warehouse

Govern access per user in Gemini

Rig applies role-based access and inherited warehouse permissions, so what each person can query through Gemini matches what they are allowed to see, with sensitive columns masked.

Ask Rig

What tables can my role query?
Show headcount without exposing salaries
List the metrics available to me

Frequently asked questions

How do I connect my warehouse to Gemini?: Connect Rig to Gemini or the Gemini CLI over MCP. Rig builds the context layer over your warehouse and Gemini can then answer with governed SQL.
Does Gemini work well with BigQuery through Rig?: Yes. Rig understands BigQuery datasets and event structures, so Gemini can answer funnel, retention and revenue questions over BigQuery data.
Will Gemini give consistent numbers?: Yes. Rig answers from agreed metric definitions and validates each query in a sandbox.
Which warehouses are supported with Gemini?: Snowflake, BigQuery, Redshift, Postgres and DuckDB/MotherDuck, plus SaaS sources synced by Rig Ingest.