Discover how to write data from a Datalab notebook to BigQuery.
- [Instructor] After you perform all your exploratory…analytics, you might want to persist intermediate…or final results back to BigQuery for later use.…Let's look at how we can save a data frame back to BigQuery.…We will continue to use the cust_df data frame…for this example.…First, we extract the schema for the new table…from the data frame schema.…This is done by using the function from data…and passing the cust_df as the parameter.…
This is stored in the schema variable.…Then we create a new table using the bq.Table command.…The table name is Type1Customers…under the data set EDA.…The create function creates a table.…We pass the schema for the table…based on what we just created before.…We say overwrite is true, so the table will be overwritten…if it already existed.…We then insert data into the table by using…cust table.insert, and passing the data frame…as the reference.…
We can then go to the BigQuery console now,…and the newly created table should show.…If you do not see the table showing up,…just refresh your browser so the list…
- 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.