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.

Book a demo

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

Discount approval tool

Build a tool to validate, approve, and keep track of discounts and offer redemptions.

Inventory management dashboard

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

Build a custom Google Sheets dashboard 10x faster

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

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

David Boskovitz

Software Engineer at Envoy

As an engineer, I love Retool. My team now builds much-needed tools for customer support instantly. Also love how it's so hackable - there's little we can't do.

Try Retool today

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

Schedule a demo