Google BigQuery
Run queries and add, update and delete rows in Google BigQuery.
About
Powered by Zapier.
What is Google BigQuery?
Google BigQuery is Google Cloud's serverless data warehouse for storing and analyzing large datasets with SQL. Analysts and data teams run queries, load data and keep tables current. This connection lets Fabric's assistant query and update BigQuery, in plain language.
What Fabric's assistant can do with Google BigQuery
Once Google BigQuery is connected, Fabric's AI assistant can work with your data from a simple request.
Run queries. Run a Query runs SQL, and the assistant can find a row or get rows from a completed job. Ask for last month's signups by country.
Add and update rows. Create Row and Create Rows add data, Update Row(s) changes it, and Find or Create Record avoids duplicates.
Load and delete data. Import Data loads data into a table, and Delete Rows removes rows. API Request (Beta) reaches the BigQuery API for anything else.
You stay in control
The assistant works from your instructions, and it confirms with you before updating or deleting rows or importing data, unless you've told it not to for a particular task. Queries run on your Google Cloud project and are billed by Google.
When a job should run regularly, a Fabric AI job can run on a schedule, such as a weekly metrics query written to a note. The connection also includes events, such as New Row, Updated Row and New Job Completed, which can start an automation.
Search your data from Fabric
Connecting Google BigQuery also adds keyword search over its records from Fabric's main search.
How people use it
Product managers ask a quick question of product data.
Data teams add a lookup row without opening the console.
Founders get a weekly metrics summary in Fabric.
Marketers pull campaign numbers for a report.
Frequently asked questions
What does the Google BigQuery connection do?
It lets Fabric's assistant run queries, find, create, update and delete rows, and import data, and it adds keyword search in Fabric.
Can I query BigQuery with AI?
Yes. Ask in plain language and the assistant writes and runs the SQL.
Can it add rows?
Yes. Create Row and Create Rows add data.
Can it delete data?
Yes. Delete Rows removes rows, after you confirm.
Does querying cost money?
Queries are billed to your Google Cloud project.
Does the assistant change data on its own?
No. It acts on your instructions.
Is my data secure?
Everything in Fabric is encrypted in transit and at rest, and the connection acts with your Google Cloud permissions. See the privacy and security guide.
Does Fabric work with other Google tools?
Yes. You can also connect Google Sheets and Google Drive.
What is Fabric?
Fabric is an AI workspace for your projects, ideas, and files.
Save anything – PDFs, images, links, notes, voice memos, videos – and search across all of it by meaning, not just keywords. Think visually on an infinite canvas, connect your tools like Gmail, Google Drive, Notion, and Figma, and work alongside a personal AI assistant that knows your work, remembers your context, and gets smarter the more you use it.
Available on web, iOS, Android, and desktop.
