BigQuery Productivity Hack — Execute Multiple Queries in a Single Tab

Share on facebook
Share on google
Share on linkedin
Share on twitter

The Problem

Whether you’re using BigQuery to explore a dataset or work on a company project, more often than not, you are working on more than one query at a time.

However, you lose old results after writing a new query — and re-running the previous query is a bit time-consuming. The quick fix? Open multiple Chrome tabs running BigQuery, with each tab containing a different query.

For some, switching across queries in separate Chrome Tabs (holy RAM usage, Batman!) is manageable. For others, it can be annoying to find that specific query amongst a sea of indistinguishable tabs. You’d have an easier time finding Waldo. 

Which query is in which tab?

A better way (pt.1)

As preparation for building the first iteration of superQuery’s IDE, we spoke with over 2,000 BigQuery users to learn how we could help them get the most out of BigQuery.

During those conversations, this tab issue was brought up a lot. Out of this, Multi-Tab Support for BigQuery was born. You could now separate queries into tabs and label them (ex. April Revenue) to quickly identify them later. Each tab even had its own results grid — no more re-running queries!

create-multiple-query-tabs-in-bigquery
Multi-Tab Support: Organize queries into tabs. Label them to easily find them later.

A better way (pt.2)

Building on this, users wanted us to go further — especially those with a background in SQL Server Management Studio. They wanted to be able to run multiple SELECT statements in a single tab, and view each query’s results. This was actually our most popular feature request over the last 5 months!

For instance, if you’re exploring a dataset you might want to quickly see the progression of your results as you go along. Now that’s possible.

Simply write out your queries, separated by semicolons, and watch the results spit out faster than you can say “SELECT 1; SELECT 2; SELECT 3;“.

Here’s how it works:

execute-multiple-queries-in-single-tab-bigquery
Run multiple queries in a tab, separated by semicolons. Each query gets its own results tab.

Your Turn

Time for you to try it out yourself! 

To use it, add the superQuery Chrome extension, or log in to superQuery if you’re already a user.

Close Menu