From the course: Data Warehousing on Google Cloud Platform

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Using Google Cloud Shell for BigQuery

Using Google Cloud Shell for BigQuery - Google Cloud Platform Tutorial

From the course: Data Warehousing on Google Cloud Platform

Start my 1-month free trial Buy for my team

Using Google Cloud Shell for BigQuery

“

- [Instructor] As mentioned earlier, the tasks we've done within the web UI are also available to us from the command line. This is helpful when we are creating programming scripts, and it's lightweight, so performing commands on the command line run much faster compared to running them within the UI. A time saver that's available within the web UI is Google Cloud Shell. You don't need to have to download the SDKs locally and can run command lines through a secure shell connection via your web browser. You can access the Cloud Shell at the top of the web console. All BigQuery commands begin with BQ. For example, to run a query, we'll use the query command and specify that we will not be using Legacy SQL. We'll also add the query within SQL quotes. Let's run by hitting Enter, and the results show within the Cloud Shell. You can also send the results to a table by setting the destination table option. Hit Enter. We'll see our status, we're done. After running this in Cloud Shell, we can…

Contents