'Is it possible to disable null values from firebase events in Big Query?

Is it possible to disable or completely ignore the null values in BigQuery that come from firebase events of a (mobile) app?

Example:

key => my_custom_firebase_event:

value => {"string_value": null, "int_value": "123456789", "doube_value":null}

Preferred:

value => {"int_value": "123456789"}

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source