Replace NULL values

Replace NULLs

Explore this snippet here.

Description

An essential part of cleaning a new data source is deciding how to treat NULL values. The BigQuery function IFNULL can help with replacing NULL values with something else: