Skip to content

Databases

BigQuery
integration

Turn BigQuery SQL queries and datasets into interactive business applications.

Start buildingRead the setup guide

Configure your connection, create queries, and build the interface your team needs. Try a sample prompt

Connector capabilities

What can ToolJet do with BigQuery?

Create queries for the operations your app needs, then connect their inputs and results to the interface.

  • Run SQL queries
  • List datasets and tables
  • Insert and update records
  • Bulk insert and upsert

Operations and configuration can vary by connector version. Check the full BigQuery guide.

An app you could build

Customer segmentation dashboard

Let analysts choose segment criteria, query the warehouse, and inspect the matching customer records in a ToolJet table.

Try this prompt

I have customers and orders tables in a BigQuery analytics dataset. Build a customer segmentation dashboard with region and order-value filters. Show matching customers, segment totals, and the orders for a selected customer.

Start with this prompt in ToolJet. Sign in or create an account, then connect your data source and replace the example names and fields with yours.

Review the generated app, configure permissions, and test its queries before sharing it with your team.

Explore app templates

Watch it come together

Build a BigQuery sales analytics app

Published · Watch on YouTube

Watch ToolJet AI turn a single prompt and BigQuery’s TheLook ecommerce dataset into a two-page sales analytics app, with sales KPIs, revenue trends, product performance, customer metrics, and cohort retention.

The video uses ToolJet AI. Use the prompt alongside it to start a similar app in ToolJet’s AI builder, then configure your connections and permissions.

Try this prompt

I have TheLook ecommerce data in BigQuery. Build a two-page sales analytics app with sales KPIs, revenue trends, product and brand performance, and order heatmaps. Add customer metrics, conversion funnels, geographic revenue, traffic sources, demographics, and cohort retention. Query BigQuery directly and let users filter by date range, country, and product category.

Start with this prompt in ToolJet. Sign in or create an account, then connect your data source and replace the example names and fields with yours.

Frequently asked questions

What can I do with the BigQuery integration?
Turn BigQuery SQL queries and datasets into interactive business applications. Supported capabilities: Run SQL queries; List datasets and tables; Insert and update records; Bulk insert and upsert.
What do I need to connect BigQuery to ToolJet?
Access to the BigQuery account or endpoint you intend to connect, with the credentials and permissions specified in its setup guide.
What should I check before using BigQuery in production?
Use credentials with only the permissions your app needs. Filter and paginate query results, and enforce access restrictions in the database or server-side queries.
Can I automate tasks with BigQuery?
Connect BigQuery queries to app events such as button clicks and form submissions. ToolJet Workflows and Agent Builder can orchestrate supported connectors on Self-hosted deployments; those products are not available on ToolJet Cloud. Check the connector and deployment requirements for your use case.

Keep exploring

Related integrations

Browse all integrations
Amazon AthenaAmazon RedshiftAppwriteAzure Cosmos DBClickHouseCouchbase

Put BigQuery to work
in your next internal app.

Connect your data, build an interface, and give your team a focused workspace.

Start buildingBook a demo

Connector information reviewed 2026-09-25. Source: ToolJet documentation.