Google Analytics, Dataform, Bigquery, Google Cloud Platform, Sql.
intermediary tables with unnested parameters. Both tables will be a lot cheaper to query than the raw export. Always have a clear goal in mind what purpose each table serves! Partitioning vs Sharding Another interesting aspect of the GA4 export is that it uses sharding instead of partitioning.