-
It appears you are struggling with stitching together data from numerous schemas in Google’s BigQuery. You attempted to use the UNION ALL command to consolidate the data, but the amount of schemas rendered this approach ineffective. Given the details, it seems that the SQL code you’ve attempted to use is unable to function as anticipated. When dealing with such large amounts of data, it might help to break it down to smaller and manageable subsets for processing. Further troubleshooting or iterative approach might be beneficial. Providing the complexity of the issue, seeking help from specialists or community forums related to Google BigQuery might also be helpful, since they can provide more code specific advice or better strategies to manage huge data schemas.
