In our product, one user has multiple accounts. Each account data is stored in different dataset in Big Query. Because there was no dependency or communication between two accounts, this approach was taken. But now we have a requirement where we calculate and send data for all user's accounts. Because every account data is present in different dataset, right now we are obliged to loop through every account and get the data. This turned out to be not time efficient process. Is there a way, we can select data from multiple datasets in a single query? Or even a way to join tables from different datasets may help us.
Currently we are looping through every account, and after getting data for every account, we are using calculated all users account data.
