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.
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!
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: