Replace empty strings with NULLs

Replace empty strings with NULLs

Explore this snippet here.

Description

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