Core Library

After connecting Retool to BigQuery, you can easily run queries, visualize your schema, and auto-complete SQL queries in our IDE. Manage, manipulate, and visualize your data with useful components like tables and graphs instead of endless scrolling through result sets.

Industry

Software as a Service•

End users

Engineering•

Components

Table

Text

Text Input

Dropdown

A fast and simple BigQuery admin console

Components

Build from a handful of drag-and-drop components

Table display the output of a query and control your table appearance and the visible columns.

Text the simplest components out there — use text components statically as labels, or dynamically to display values.

Button trigger actions that do things like run queries, export data, or open other apps.

Text Input take a text input to modify the parameters of a query — say the `ILIKE` in a SQL statement, or a URL parameter in a REST query based on the value of the component.

Dropdown allow users to select one value from a list of options.

Container organize your admin panel by using containers as top-level components and to nest other components.

Data source

Connecting Retool to BigQuery takes just a few minutes and lets you build user interfaces on top of your BigQuery data. Just grab the private key from your Service Account with BigQuery privileges, and you're ready to go. For example, you can pull your event data by user into a Table component, and join it with data from Stripe to map payments to product activity.

1. Create resource

2. Read data

3. Connect data with UI

Related use cases

What you can build with Retool

A fast and simple custom Firestore admin interface

Build your own custom Firestore admin interface to easily query your database.

A fast and simple Firebase auth admin panel

All the stuff you want to do in the Firebase UI but can't. Easily view, add, edit, and delete users.

Inventory management dashboard

Build an app to see what's in stock, add SKUs, track the status of orders.

From startups to Fortune 500s, the world's most effective teams use Retool to build custom business software. Our customers

Eddy Kim

Engineering Manager at Verishop

Using Retool, we've built internal tools for our retail and merchandising teams quickly, while maintaining our speed on feature development for our shoppers.

Try Retool today

Start building an internal tool or customer portal in under 10 minutes

Schedule a demo