Integrations / Databases
Google BigQuery on WhatsApp: manage tables and reservations with an AI agent
Flann turns Google BigQuery into something you can message. Ask on WhatsApp, by text or voice note, and Flann does the work in Google BigQuery for you. Weekly numbers, monthly comparisons, the odd question late at night. Flann reads Google BigQuery whenever you ask and keeps the answers short enough for a phone screen. When you want a deeper view, ask a follow-up in the same chat.
62 actions in Google BigQuery. 33 only look things up, and 29 create, update, send or delete. You connect with a one-click sign-in.
What you can ask Flann to do in Google BigQuery
You do not need the exact wording. These are the kinds of messages Flann turns into Google BigQuery actions.
“Show me my projects in Google BigQuery.”
“Look up the service account in Google BigQuery.”
“Show me my models in Google BigQuery.”
“Create a table in Google BigQuery.”
“Create a dataset in Google BigQuery.”
“Create a routine in Google BigQuery.”
What Flann can work with in Google BigQuery
Google BigQuery gives Flann 62 actions across 23 kinds of record. These are the ones you are most likely to use.
| Record | What Flann can do | Actions |
|---|---|---|
| Tables | createdeletelook upupdate | 6 |
| Reservations | createlook up | 2 |
| Datasets | createdeletelook upupdate | 5 |
| Routines | createdeletelook upupdate | 5 |
| Connections | createlook upupdate | 4 |
| ML models | deletelook upupdate | 3 |
| Reservation assignments | createlook upsearch | 3 |
| Analytics hub listings | createlook up | 2 |
Here is what changes when Google BigQuery goes through Flann instead of its own screens.
| Compare | Google BigQuery on its ownEvery step is yours | With FlannThe work comes to your chat |
|---|---|---|
| How you ask | Log in and click through the screens | Text or voice note, in your own words |
| Looking things up about tables | By hand, screen by screen | 33 look-ups, answered straight away |
| Creating and updating | Typed in by hand | 29 changes, made from a message |
| Google BigQuery records | All of them, one screen at a time | 23 kinds, from one chat |
| Set-up | Nothing new to set up | One sign-in to Google BigQuery |
YesPartlyNo
Step by step: Google BigQuery jobs you can hand to Flann
How a request turns into real Google BigQuery actions, one step at a time.
Create a table from a voice note
- You message Flann on WhatsApp: “Create a table in Google BigQuery with these details.”
- Flann runs
List BigQuery Table Datain Google BigQuery and shows you what it found. - Flann runs
Create BigQuery Tablein Google BigQuery. - Flann creates it in Google BigQuery and confirms in the chat.
Fix a dataset without opening Google BigQuery
- You message Flann on WhatsApp: “Change the dataset in Google BigQuery: here is what is different.”
- Flann runs
List BigQuery Datasetsin Google BigQuery and shows you what it found. - Flann runs
Update BigQuery Datasetin Google BigQuery. - Flann makes the change in Google BigQuery and confirms in the chat.
Clean up routines you no longer need
- You message Flann on WhatsApp: “Which routines in Google BigQuery are out of date? Remove the ones I confirm.”
- Flann runs
List BigQuery Routinesin Google BigQuery and shows you what it found. - Flann runs
Delete BigQuery Routinein Google BigQuery. - Each removal is confirmed in the chat.
Where Flann saves you time in Google BigQuery
Small jobs, repeated often, are where the time goes. Here is how they change once Google BigQuery is connected.
Keeping an eye on competitors
Today
Checking what nearby competitors charge means visiting several websites and writing it all down. So it happens once a year, if that.
With Flann
“Use Google BigQuery to check what the gyms near us charge for a monthly membership.”
Using Google BigQuery, Flann gathers the published membership prices from those gyms’ websites and lays them out next to yours in one short table. It notes the date it checked, since prices change. Nothing on your side changes, and nothing is sent anywhere.
What you stop doing: Visiting competitor websites one by one with a notepad is a thing of the past.
Cleaning up duplicate records
Today
The same customer appears in Google BigQuery three times with slightly different spellings. Reports count them separately, and nobody gets round to merging them.
With Flann
“Find duplicate customers in Google BigQuery and show me what you’d merge.”
Records in Google BigQuery that share a phone number, an email or a close spelling are grouped as likely duplicates.
What you stop doing: Merging duplicate records one by one is no longer on you.
More on this: how to hand repetitive tasks to an AI agent on WhatsApp.
How Flann connects to Google BigQuery
- Open Connectors in Flann and choose Google BigQuery.
- Sign in to your Google BigQuery account on the secure page that opens and allow access. There is no developer account or API key to set up.
- From then on, message Flann on WhatsApp. It works in Google BigQuery whenever a request needs it.
Of the 62 Google BigQuery actions, 33 only read. The other 29 create, update, send or delete. Disconnect Google BigQuery in Connectors whenever you like.
Ways to use Google BigQuery with Flann
Spot what changed
Ask what went up or down. Flann checks Google BigQuery and tells you what moved.
Ask, do not dig
Ask how this week compares to last. Flann pulls the numbers from Google BigQuery and answers in plain words.
A weekly summary on demand
Ask Flann for the week in brief. It reads Google BigQuery and sends the few numbers worth knowing.
Everything Flann can do in Google BigQuery
Every Google BigQuery action Flann can run, split into what it reads and what it changes.
Looks up 33
- Get BigQuery Dataset Metadata
- Get BigQuery Job
- Get BigQuery Query Results
- Get BigQuery Table Schema
- List BigQuery Datasets
- List BigQuery Jobs
- List BigQuery Models
- List BigQuery Projects
- List BigQuery Table Data
- List BigQuery Tables
- Get BigQuery Connection IAM Policy
- Get BigQuery ML Model
- Get BigQuery Routine
- Get BigQuery Routine IAM Policy
- Get BigQuery Service Account
- Get BigQuery Table IAM Policy
- List Analytics Hub Listings
- List Analytics Hub Query Templates
- List BigQuery Capacity Commitments
- List BigQuery Connections
- List BigQuery Data Transfer Locations
- List BigQuery Location Data Policies
- List BigQuery Reservation Assignments
- List BigQuery Reservation Groups
- List BigQuery Reservations
- List BigQuery Routines
- List BigQuery Row Access Policies
- List Connections in Location
- List Data Exchange Listings
- List Organization Data Exchanges
and 3 more
Changes 29
- Create Analytics Hub Listing
- Create BigQuery Dataset
- Create BigQuery Routine
- Create BigQuery Table
- Delete BigQuery Dataset
- Delete BigQuery ML Model
- Delete BigQuery Table
- Insert BigQuery Job
- Insert BigQuery Job with Upload
- Insert Data into BigQuery Table
- Patch BigQuery Dataset
- Patch BigQuery ML Model
- Patch BigQuery Table
- Undelete BigQuery Dataset
- Update BigQuery Dataset
- Update BigQuery Table
- Cancel BigQuery Job
- Create Analytics Hub Data Exchange
- Create Analytics Hub Query Template
- Create BigQuery Connection
- Create BigQuery Data Policy (v2beta1)
- Create BigQuery Reservation
- Create BigQuery Reservation Assignment
- Create Capacity Commitment
- Delete BigQuery Job Metadata
- Delete BigQuery Routine
- Set BigQuery Routine IAM Policy
- Update BigQuery Connection
- Update BigQuery Routine
More Databases apps Flann works with
Google Analytics
MixpanelCommon questions
What can Flann do with tables in Google BigQuery?
Flann can create, delete, look up and update tables in Google BigQuery, using 6 actions (Create BigQuery Table, Delete BigQuery Table, List BigQuery Table Data, List BigQuery Tables and more). Looking up runs straight away and changes nothing. The other actions create or change tables in Google BigQuery.
What can Flann do with reservations in Google BigQuery?
Flann can create and look up reservations in Google BigQuery, using 2 actions (Create BigQuery Reservation, List BigQuery Reservations). Looking up runs straight away and changes nothing. The other actions create or change reservations in Google BigQuery.
How does Flann connect to Google BigQuery?
Open Connectors in Flann, choose Google BigQuery and sign in to your Google BigQuery account on a secure page. There is no developer account or API key to set up. Once it is connected, Flann can use 62 actions in Google BigQuery.
Do I need to open Google BigQuery to use it with Flann?
No. Once Google BigQuery is connected, you ask Flann on WhatsApp or in the Flann app, by text or voice note, and it does the work in Google BigQuery.
Does connecting Google BigQuery cost extra?
No. Google BigQuery is included in every Flann plan, along with every other app Flann connects to.