Learn how to execute BigQuery commands from a Datalab notebook.
- [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 with these commands more.…
- Setting up Cloud DataLlb for exploratory data analytics
- Segmentation and profiling
- Reading and writing data from BigQuery
- Managing cloud storage buckets
- Creating visualizations of BigQuery data with the GCP Charting API
- Managing Datalab instances
Skill Level Intermediate
Predictive Customer Analyticswith Kumaran Ponnambalam1h 37m Intermediate
1. Exploration Options in GCP
2. Cloud Datalab Basics
3. Datalab: BigQuery
4. Datalab: Cloud Storage
5. Datalab: Visualizations
6. EDA with GCP: Use Case
7. Managing Datalab
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.