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

Syntax

Connect-GoogleBigQuery -EmptyArraysAsNull bool

Data Type

bool

Default Value

true

Remarks

When this property is set to true, the cmdlet represents empty arrays as "null". This aligns with how the cmdlet 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 cmdlet.

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.