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

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

Build a custom Google Sheets dashboard 10x faster

Build dashboards, admin panels, workflows, and more. Save hundreds of hours.

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.

A fast and simple admin panel template

Save hundreds of hours with pre-made templates, integrations, and components.

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

Dean McRobie

CTO at CommonBond

I tell every technology leader I talk to that they should look at Retool as a way to reduce the burden of building admin UIs and democratize that kind of stuff across their company.

Try Retool today

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

Schedule a demo