Simplify Data Cleaning With BigQuery SQL User-Defined Functions
Introduction and use cases
Published in
5 min readApr 20, 2023
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…