See All Videos

Save Time with Keyboard Shortcuts in the BigQuery Console

By Jon Schwab
September 21, 2020

In this tutorial, we’ll look at keyboard shortcuts in the BigQuery console, including a couple like toggling comments and multiple cursors that may be familiar from other text editing programs.

View Transcript

Today, we’re going to talk about saving time by using shortcuts in the BigQuery Console window. First one we’re going to talk about is running the entire query. So we’re going to use Command-Enter on Mac or Ctrl-Enter on Windows. So there it is. If we want to just run part of the query we can highlight it here and we’ll hit Command-E on the Mac or Ctrl-E on Windows. Now this one is going to be familiar for people who use Sublime Text. So let’s say that we want to comment out part of the query. So I’m going to highlight what we have here, and I’m going to hit Command-/ on a Mac or Ctrl-/ on Windows. If I want to uncomment out, it’s going to be the exact same thing. So Command-/ on Mac or Control-/ on Windows.

The last one I’m going to talk about is also going to be familiar to people who use a Sublime Text or Visual Studio Code, and that is multiple cursors. So why would you want to do that? So let’s look at this query here and you can see that we have three instances of this rating column saying… Let’s say that we want to change this. Let’s look at the columns that we have here. And let’s say that we want to change this to numb votes. So I’m going to position the cursor after one of the instances of that column. So we’ll put it here and I’m going to hit a Command-Option on the Mac. Now hold that down. And you can also use a Ctrl-Alt on Windows. And I’m going to click right here and right here, and you can see that now I have a cursor for each one of those instances and I’m going to hit Backspace. [inaudible 00:01:53] So now you can see it kind of works like a Find and Replace, we’ve got those replaced.

So hope that helps. And you can see we’ve got all these summarized here. And if you’re interested, please subscribe for more information on Data Studio, Google Analytics and Google Tag Manager.

Still need help?

About the Author
Jon has been figuring out ways to solve problems with technology for over ten years. He is passionate about finding simple solutions and is a fan of functional programming concepts in languages like Python, JavaScript and Elixir. When not online, he likes camping and spending time with his wife and daughter.
More from this author
Ready to start a project?
let's work together