Comparison of Google Analytics 4 and Universal Analytics Big Query export Schemas, as documented on https://support.google.com/analytics/answer/3437719?hl=en and https://support.google.com/analytics/answer/7029846?hl=en

The format and schema of the data that is imported into BigQuery from Google Analytics 4 as explained in Google Documentation https://support.google.com/analytics/answer/7029846?hl=en

The format and schema of the data that is imported into BigQuery from Universal Analytics as explained in Google Documentation https://support.google.com/analytics/answer/3437719?hl=en See original publication from Donal Phipps https://rpubs.com/Phippsy/bq-export