From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Reading data from BigQuery - Google Cloud Tutorial
From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
Reading data from BigQuery
- [Instructor] Now we are ready to read data from BigQuery using the command line. Here is the query. We select customer name, gender, age, and salary from the website visits table where the type of customer is one. We limit to only 10 records. The command we use is bq query. The actual query should be in the second line. On executing the query the results are directly printed in the notebook. You can also create a named query. You do so by using the attribute name and providing an actual name here. In this example we create a query called customer using the same example as before. Once a named query is created, it is not executed immediately. This name can later be referenced in other operations as we will see in future videos. The query gets executed only when the data needs to be used for the next operation. A named query, once created, can be used in any number of future operations.
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.