Colab + BigQuery — Perfect Together

Marc Cohen
Google Colab
Published in
2 min readJan 12, 2023
Photo by benjamin lehman on Unsplash

Have you heard about Google BigQuery? It’s hard to summarize all of the advantages in one sentence but I’m going to try anyway: BigQuery is a fully managed, cloud-native data warehouse that enables incredibly fast SQL queries using the processing power of Google’s infrastructure.

If you haven’t had an opportunity to try BigQuery, today’s notebook, courtesy of Google Developer Advocate Alok Pattani, is a treat. In Alok’s notebook, you’ll learn how to use BigQuery to perform some basic data science tasks, including:

  • setting up Colab and Google BigQuery within Colab
  • reading data from BigQuery into Colab
  • using Python data science tools to do some analysis/curve fitting
  • creating some interactive outputs
  • using Python functionality “on top” of BigQuery to scale analysis
  • writing some analysis results back into BigQuery

In addition to mind-bending performance, BigQuery is scalable, serverless, cost effective, secure, and plays well with other Google Cloud services.

Run the notebook and see how easy it is to use a world class data warehouse from the free, zero-friction Colab environment.

--

--

Marc Cohen
Google Colab

Engineer@Google - My mission is building tools, tutorials, and other educational artifacts to make computing and data science more accessible and inclusive.