From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
BigQuery commands - Google Cloud Tutorial
From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
BigQuery commands
- [Instructor] We will use the exercise file 03_XX_Using_BigQuery_with_Datalab for the rest of the examples in this chapter. Let us first open the notebook. We go to the notebook name shown in the Datalab Notebook Viewer and click on it. Once it is open, go and do a run all cells to make sure it re-executes against the current newly created datasets. Let us explore some BigQuery commands now. While executing BigQuery commands or bq commands, we need to use a separate code cell in the notebook. Commands cannot be combined with any other Python code. Commands start with a double percentage markup. First, we will execute the help command for the bq tool. This is bq --help. This command shows all the capabilities available from the bq command line. We can list tables, execute queries and load data. As an example, we will list all the tables in BigQuery using the bq tables list command. This shows all the tables in the project with its fully qualified name. I recommend that you experiment…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.