UpbuildWritten by Uptimal, the team that builds and operates Upbuild and runs marketing analytics for multinational clients across the globe. Everything below reflects how the connector actually behaves in production.
Your marketing data probably already lands in BigQuery: GA4’s native export, an ad-platform pipeline, a warehouse your data team owns. The gap has never been the storage, it is that answering “what did Search cost per conversion last quarter” means opening the console, remembering the table name, and writing SQL. Upbuild’s BigQuery family closes that gap: five read-only tools that let Claude, ChatGPT, Copilot Studio or Gemini Enterprise reach the warehouse you already have.
What the assistant can actually call
bigquery_list_projects: the Google Cloud projects this sign-in can reach.bigquery_list_datasets: the datasets inside one project.bigquery_list_tables: the tables inside one dataset.bigquery_get_table: one table described, every column and its type, plus its size.bigquery_query: a read-only SQL query, rows returned into the chat.
That order matters. An assistant that has to guess a table name hallucinates one; an assistant that can list datasets, list tables and read a schema first writes SQL against columns it has actually seen.
Read-only by enforcement, not by convention
This is the one place in Upbuild where your assistant writes SQL, so the guard is not a promise in a system prompt. The statement is parsed before it runs. It must begin with SELECT or WITH, and it is refused outright if it contains INSERT, UPDATE, DELETE, MERGE, CREATE, DROP, ALTER, TRUNCATE, GRANT, REVOKE, CALL, EXECUTE, EXPORT, LOAD, BEGIN, COMMIT, DECLARE or SET as a whole word. A prompt injection that tells the model to drop a table gets a refusal from the server, not a judgment call from the model.
Questions that work on day one
- “What tables are in my marketing dataset, and which one has last month’s spend?”
- “Describe the campaign performance table: what columns and types does it have?”
- “Top 20 campaigns by conversions last quarter from the warehouse, and how does that compare to what Google Ads reports today?”
The last one is the interesting one, and it is the reason a BigQuery MCP beats a SQL client: the same assistant holds your warehouse and your live Google Ads account in one conversation, so the reconciliation happens in the answer instead of in a spreadsheet afterwards.
Access is your access
The connection is per-user OAuth on your own Google account. The assistant reaches the projects that sign-in already reaches, nothing more, and a teammate connecting their own login gets their own reach. Nothing is copied into Upbuild: queries run in your project, against your quota, and the rows come back into the chat.
Ask your ad platforms directly, in Claude, ChatGPT, Copilot Studio or Gemini Enterprise.
Upbuild is a read-only MCP connector for your marketing platforms: 80 tools, live data, a 14-day free trial with no card.
Start free trial → Talk to usFrequently asked questions
Does this replace the GA4 BigQuery export?
No, it reads it. If GA4’s native export already lands events in your project, these tools are how an assistant explores and queries that data conversationally.
Can the assistant write to BigQuery?
Not through the connector: bigquery_query refuses anything that is not a SELECT or WITH statement. Scheduled writes into a table you choose are an Upbuild Enterprise feature, set up deliberately rather than by a chat message.
Whose BigQuery quota does a query use?
Yours. Queries execute in your own Google Cloud project under your own sign-in, so billing, quotas and access controls stay where your data team put them.