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

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.