Simplify Data Cleaning With BigQuery SQL User-Defined Functions

Introduction and use cases

Vicky Yu
Towards Data Science
5 min readApr 20, 2023

--

Photo by Brooke Cagle on Unsplash

A large portion of any data-related job is data cleaning but often times writing SQL statements can be tedious, especially coding the same SQL logic over multiple columns in a table. This is until I discovered I could create user-defined functions (UDFs) in BigQuery to meet my specific data cleaning use case…

--

--

Musings of a data scientist turned data analyst. Sharing my data experiences one story at a time.