Connect BigQuery to Your AI Agent
Connect TextQL to Google BigQuery and let Ana answer business questions across your entire data warehouse. Get insights in seconds — with the SQL and cost estimate attached to every answer.
Setup video
TextQL's BigQuery connector gives your AI agent direct access to query your data using natural language. Upload a GCP service account key JSON file or authenticate via Google OAuth. Select your default project and TextQL will auto-discover all accessible datasets, tables, and views.
Everything you need to know
Setup walkthrough
Watch how to connect BigQuery to TextQL in under 5 minutes.
Getting started
Your first steps in TextQL — quickstart, connecting data, and your first chat.
Documentation
Technical reference for the BigQuery connector — auth, schema, config.
Pricing
Explore plans — all connectors included on every tier. No per-connector fees.
Yes. TextQL fully supports BigQuery's STRUCT and ARRAY column types. When you ask a question involving nested data, Ana automatically generates the correct UNNEST operations and field path references. You don't need to know the schema structure — just ask your question and Ana handles the complexity.
Connect to any of your other data sources
TextQL connects to 63+ data sources. Query BigQuery alongside any of these — or join data across multiple sources in a single question.
Snowflake
Databricks
Redshift
Tableau
'%3e%3cpath%20d='M1400%2066.75v1466.5c0%2036.86-29.89%2066.75-66.75%2066.75h-416.5c-36.865%200-66.75-29.89-66.75-66.75V66.75C850%2029.885%20879.885%200%20916.75%200h416.5c36.87%200%2066.75%2029.885%2066.75%2066.75z'%20fill='url(%23prefix__paint0_linear_8592:56198)'/%3e%3cg%20filter='url(%23prefix__filter0_dd_8592:56198)'%3e%3cpath%20d='M1075%20466.667V1600H525V466.667C525%20429.848%20554.848%20400%20591.667%20400h416.663c36.82%200%2066.67%2029.848%2066.67%2066.667z'%20fill='url(%23prefix__paint1_linear_8592:56198)'/%3e%3c/g%3e%3cpath%20d='M200%20866.667v666.663c0%2036.82%2029.848%2066.67%2066.667%2066.67H750V866.667C750%20829.848%20720.152%20800%20683.333%20800H266.667C229.848%20800%20200%20829.848%20200%20866.667z'%20fill='url(%23prefix__paint2_linear_8592:56198)'/%3e%3c/g%3e%3cdefs%3e%3clinearGradient%20id='prefix__paint0_linear_8592:56198'%20x1='758.333'%20y1='0'%20x2='1447.82'%20y2='1507.15'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%23E6AD10'/%3e%3cstop%20offset='1'%20stop-color='%23C87E0E'/%3e%3c/linearGradient%3e%3clinearGradient%20id='prefix__paint1_linear_8592:56198'%20x1='524.955'%20y1='400'%20x2='1105.79'%20y2='1561.67'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%23F6D751'/%3e%3cstop%20offset='1'%20stop-color='%23E6AD10'/%3e%3c/linearGradient%3e%3clinearGradient%20id='prefix__paint2_linear_8592:56198'%20x1='199.955'%20y1='800'%20x2='519.784'%20y2='1581.68'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%23F9E589'/%3e%3cstop%20offset='1'%20stop-color='%23F6D751'/%3e%3c/linearGradient%3e%3cfilter%20id='prefix__filter0_dd_8592:56198'%20x='391.667'%20y='300'%20width='816.667'%20height='1466.67'%20filterUnits='userSpaceOnUse'%20color-interpolation-filters='sRGB'%3e%3cfeFlood%20flood-opacity='0'%20result='BackgroundImageFix'/%3e%3cfeColorMatrix%20in='SourceAlpha'%20values='0%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%20127%200'%20result='hardAlpha'/%3e%3cfeOffset%20dy='6.333'/%3e%3cfeGaussianBlur%20stdDeviation='6.333'/%3e%3cfeColorMatrix%20values='0%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200.2%200'/%3e%3cfeBlend%20in2='BackgroundImageFix'%20result='effect1_dropShadow_8592:56198'/%3e%3cfeColorMatrix%20in='SourceAlpha'%20values='0%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%20127%200'%20result='hardAlpha'/%3e%3cfeOffset%20dy='33.333'/%3e%3cfeGaussianBlur%20stdDeviation='66.667'/%3e%3cfeColorMatrix%20values='0%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200.18%200'/%3e%3cfeBlend%20in2='effect1_dropShadow_8592:56198'%20result='effect2_dropShadow_8592:56198'/%3e%3cfeBlend%20in='SourceGraphic'%20in2='effect2_dropShadow_8592:56198'%20result='shape'/%3e%3c/filter%3e%3c/defs%3e%3c/svg%3e)
Power BI
Postgres
'/%3e%3cpath%20d='M63.7076%20110.284C60.8481%20113.885%2055.0502%20111.912%2054.9813%20107.314L53.9738%2040.0627L99.1935%2040.0627C107.384%2040.0627%20111.952%2049.5228%20106.859%2055.9374L63.7076%20110.284Z'%20fill='url(%23paint1_linear)'%20fill-opacity='0.2'/%3e%3cpath%20d='M45.317%202.07103C48.1765%20-1.53037%2053.9745%200.442937%2054.0434%205.041L54.4849%2072.2922H9.83113C1.64038%2072.2922%20-2.92775%2062.8321%202.1655%2056.4175L45.317%202.07103Z'%20fill='%233ECF8E'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear'%20x1='53.9738'%20y1='54.974'%20x2='94.1635'%20y2='71.8295'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%23249361'/%3e%3cstop%20offset='1'%20stop-color='%233ECF8E'/%3e%3c/linearGradient%3e%3clinearGradient%20id='paint1_linear'%20x1='36.1558'%20y1='30.578'%20x2='54.4844'%20y2='65.0806'%20gradientUnits='userSpaceOnUse'%3e%3cstop/%3e%3cstop%20offset='1'%20stop-opacity='0'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e)
Supabase
ClickHouse
Azure SQL
Aurora
MotherDuck
MySQL
SQL Server
Oracle
Athena
SAP HANA
Trino
Salesforce
HubSpot
Attio
Pipedrive
Notion
Confluence
Microsoft Teams
Asana
Monday.com
Airtable
Linear
'%20fill='%231B1F23'/%3e%3c/svg%3e)
GitHub
GitLab
Figma
Jira
Slack
Intercom
Zendesk
SendGrid
OpenAI
Anthropic
Mixpanel
Amplitude
Segment
Looker
QuickSight
Looker Studio
AWS
Google Cloud
Azure
Cloudflare
Stripe
Datadog
Sentry
PagerDuty
Grain
Oracle Fusion
Custom API
Tableau (REST API)
Power BI (REST API)
Salesforce Marketing Cloud
Salesforce Commerce Cloud
HubSpot Marketing Hub
HubSpot Sales Hub
HubSpot Service Hub