Specifies whether empty arrays are represented as null or as an empty array.

Data Type

bool

Default Value

true

Remarks

When this property is set to true, the add-in represents empty arrays as "null". This aligns with how the add-in handles empty aggregates and can help simplify downstream comparisons or processing logic.

When set to false, empty arrays are represented as "[]", which mimics the behavior of the native Google BigQuery add-in.

Enable this property to normalize the handling of empty values by treating empty arrays as "null". Disable it if your application or tools expect an explicit empty array instead.