Google Analytics, Dataform, Bigquery, Google Cloud Platform, Sql.
sweet feature to have available for free. One of the idiosyncrasies of the GA4 export is that it is optimized for storage, not querying. The most obvious sign of this is the number of nested fields. A sign of storage optimization is the number of nested fields Nesting can definitely make sense in a