Determines whether the provider flattens STRUCT fields into top-level columns.

Syntax

Connect-GoogleBigQuery -FlattenObjects bool

Data Type

bool

Default Value

true

Remarks

By default the cmdlet reports each field in a STRUCT column as its own column while the STRUCT column itself is hidden. This process is recursively applied to nested STRUCT values. For example, if the following table is defined in Google BigQuery then the cmdlet reports 3 columns: location.coords.lat, location.coords.lon and location.country:

CREATE TABLE t(location STRUCT<coords STRUCT<lat FLOAT64, lon FLOAT64>, country STRING>);

If this property is disabled, then the top-level STRUCT is not expanded and is left as its own column. The value of this column is reported as a JSON aggregate. In the above example, the cmdlet reports only the location column when flattening is disabled.