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

  • Connor

    Member
    15 June 2023 at 6:53 pm

    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.