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 server represents empty arrays as "null". This aligns with how the server 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 server.

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.