Share on facebook
Share on linkedin
Share on twitter
Share on reddit

Query Tabs for BigQuery — How to Eliminate “Query Overload”

In this article, you’ll learn how to add query tabs functionality to your BigQuery interface — and how to use tabs to simplify your workflow.

Query Overload in BigQuery

Does this sound familiar? 

You’re on an assignment, working on several queries in BigQuery — but you don’t want to lose the results of one query in order to execute another.

So what do you do?

You juggle several Chrome tabs running BigQuery, each containing a different query. But you end up more disorganized than before, with your browser probably looking like this:

messy-bigquery-console-chrome-tabs
Everyone's favorite guessing game — "Which Chrome Tab has the query I'm looking for?"

How do you know which query is where? Luckily, there’s a better way to organize your work.

 

How to Use Query Tabs in BigQuery

With multi-tab support for BigQuery (via superQuery), you’ll simplify your query management by separating your work into tabs. After opening a new query tab, you can name it to easily identify it later.

Creating a new query is as simple as clicking the “+” sign just above your SQL Editor. Each tab can even contain multiple SQL statements that you can execute at the same time in one click.

What if you want to group different tabs together into folders? That’s what Boards are for. They’re essentially workspaces you group related queries into.

Finally, tabs in superQuery come equipped with Syntax Auto-Detect. With this, you no longer need to tell Google whether you’re using Standard or Legacy syntax. superQuery detects your syntax automatically from your SQL.

Query Tabs and Boards in superQuery
Here we see a Board called "Marketing Campaigns" with its queries underneath.

Tips on Organizing

Here are some ways you can organize boards and queries (okay, maybe not the last one 😉)

User Acquisition Board

  • LTV:CAC
  • CAC
  • MRR Churn
  • AVG MRR
  • Gross Margin
  • LTV

Marketing Campaigns Board

  • Facebook
  • Twitter
  • LinkedIn
  • Quora
  • Pinterest
  • Instagram

Pokemon Pokedex

  • Easiest to Capture by Type
  • Strongest by Type
  • Strongest by Generation
  • # Pokemon by Type
…but really, the possibilities are endless! It depends on you, the data you’re examining, and how you mentally organize your data insights.

Organize your BigQuery Work

As humans, we seek organization in at least one aspect of our lives  — some even argue it is a basic human need.

Whether it’s putting your ideas into lists or setting up schedules & deadlines, we strive to organize for productivity and simplicity’s sake.

Your work in BigQuery is no different. You should focus on that next crucial insight your analysis will bring, not playing “Musical Chrome Tabs” searching for that work-in-progress query.

Now that you know why you should use tabs to give order to your BigQuery work, give it a try yourself . Peace of mind is literally one click away.

What it feels like when your queries are organized. (Photo by Barn Images on Unsplash)

Ready to run perfect queries?

Free to get started. No credit card required.

  • © 2019 superQuery. All rights reserved.

By continuing to use the website, you consent to the use of cookies.