Is there a workaround for the Multi Tenancy issue. I want to sync too many tables from multiple sources then push all the data to BigQuery for Analysis in append mode. The thing is that when pushing data to the same destination the data from different sources will get mixed up. For that I might need to add like a certain column having something like a sourceID or something so that data might not get mixed up. Is there something like that or is there any other solution for this multi Tenancy issue?
Create different datasets to each source is it not possible? You can use the
CUSTOM_NAMESPACE option to create datasets in BigQuery with the name you prefer. With this you can organize among clients or data projects.