Learn business growth with Google Analytics 4 › Forums › Google Analytics 4 › Retrieving data from multiple schemas in BigQuery › Reply To: Retrieving data from multiple schemas in BigQuery
-
The individual is experiencing difficulties managing a large amount of data from Google Analytics 4 using BigQuery, specifically when attempting to synthesize data that spans multiple schemas. They initially tried using the UNION ALL function but found it inefficient given the large number of schemas. The person attempted to write a code, but unfortunately, it didn’t produce the desired results. They are seeking a new way to efficiently aggregate and manage their data.