---
title: "Google Gemini + Rig: Query Your Warehouse Data in Google Gemini"
description: "Connect your warehouse to Google Gemini with Rig. Ask data questions in plain English and get governed, validated SQL answers. Snowflake, BigQuery, Redshift, Postgres and more."
canonical: "https://rig.so/integrations/gemini"
format: markdown
---

Browse integrations

![Google Gemini logo](https://img.logo.dev/gemini.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true)

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](https://app.rig.so/signup)[Book a demo](https://rig.so/book-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.

[Read the step-by-step guide to connecting Rig to Google Gemini](https://rig.so/guides/connect-ai-tools)

## 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.

## Related integrations

[![ChatGPT logo](https://img.logo.dev/openai.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)ChatGPTAsk your warehouse questions in ChatGPT and get governed, validated answers.](https://rig.so/integrations/chatgpt)[![Claude logo](https://img.logo.dev/claude.ai?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)ClaudeAsk questions of your warehouse in Claude, with governed SQL behind every answer.](https://rig.so/integrations/claude)[![Claude Code logo](https://img.logo.dev/claude.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Claude CodeQuery and build with warehouse data from the Claude Code terminal.](https://rig.so/integrations/claude-code)[![Cursor logo](https://img.logo.dev/cursor.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)CursorBring governed warehouse data into Cursor for data-aware coding.](https://rig.so/integrations/cursor)[![OpenAI Codex logo](https://img.logo.dev/openai.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)OpenAI CodexGive Codex governed access to your warehouse for data-aware coding.](https://rig.so/integrations/codex)[![VS Code logo](https://img.logo.dev/visualstudio.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)VS CodeQuery your warehouse from VS Code and GitHub Copilot over MCP.](https://rig.so/integrations/vs-code)

## Connect your warehouse to Google Gemini

Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust.

[Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo)

---

- [This page as HTML](https://rig.so/integrations/gemini)
- [Site map for language models](https://rig.so/llms.txt)
- [API and agent documentation](https://rig.so/developers)