Daily SQL Code to transform GA4 data from a row per event to a row per session. Set this up as a daily scheduled BigQuery task to write to a partitioned table by day.
The two addiitonal files are examples of SQL to run using the daily sessions_ data as input.