Specifies the maximum depth of array elements to flatten for report views.

データ型

int

デフォルト値

0

解説

By default, the value is set to 0, meaning that only the first level will be pushed.

If the value is set to -1, all the levels will be flattened.

The nested values of non-primitive objects will be pushed as JSON aggregates.

To access the values of those aggregates you can use the JSON_EXTRACT function.