Sign up
Sign in
Sign up
Sign in
Member-only story
Bence Komarniczky
Follow
Towards Data Science
—
Share
Google Cloud’s BigQuery is an awesome tool for data analytics and even machine learning. It comes with a load of useful functions right out of the box, but if you want to really dive into BQ you will at some point need to get comfortable with User-Defined Functions. These functions, defined by you (the user) will allow you to simplify your SQL queries and get stuff done quicker.
I will show you how you can use SQL or JavaScript to define your functions and even how you can go ahead and use some Statistical functions from jStat — a JavaScript library for statistics.
There’s a Google Colab Notebook for this whole tutorial with easy to run steps, you can recreate and steal all the code you need for your own work.
Since I prefer to write tutorials that are easily reproduced, we will start our journey by authenticating our Google Colab session:
—
—
Towards Data Science
Data scientist building ML products in ad-tech. I write tutorials on data science🧑🔬, machine learning 🤖, Julia and cloud computing ☁️.
Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams
