Presented By O'Reilly and Cloudera
Make Data Work
Dec 4–5, 2017: Training
Dec 5–7, 2017: Tutorials & Conference

BigQuery and TensorFlow: How a data warehouse + machine learning enables "smart" queries

Kaz Sato (Google)
2:35pm3:15pm Thursday, December 7, 2017
Average rating: ****.
(4.00, 1 rating)

Who is this presentation for?

  • Data scientists, data analysts, ITDMs

Prerequisite knowledge

  • A basic understanding of databases and machine learning

What you'll learn

  • Learn how to combine BigQuery and TensorFlow to enable a powerful "data warehouse + ML" solution


BigQuery is Google’s fully managed, petabyte-scale, low-cost enterprise data warehouse. By leveraging the petabit network and tens of thousands of servers in Google’s data center, BigQuery allows you to execute your SQL as a massively parallel processing query with hundreds of CPU cores and ample disk storage, scanning and aggregating terabytes of data in seconds.

BigQuery also features an unique technology, user-defined functions (UDF), that let you define your own SQL function with JavaScript code, embedded in SQL. UDF is the key to integrating the scalable data warehouse with the power of machine learning, using TensorFlow and ML Engine and enables a variety of “smart” queries, such as similarity searches and recommendations on images, documents, products, or users. You can even run neural network predictions inside BigQuery.

Kazunori Sato demonstrates how to integrate UDF with BigQuery, TensorFlow, and ML Engine and build a powerful solution with cloud data warehouses and machine learning.

Photo of Kaz Sato

Kaz Sato


Kaz Sato is a staff developer advocate on the cloud platform team at Google, where he leads the developer advocacy team for machine learning and data analytics products such as TensorFlow, the Vision API, and BigQuery. Kaz has been leading and supporting developer communities for Google Cloud for over seven years. He’s a frequent speaker at conferences, including Google I/O 2016, Hadoop Summit 2016 San Jose, Strata + Hadoop World 2016, and Google Next 2015 NYC and Tel Aviv, and he has hosted FPGA meetups since 2013.