So we would like to join data from different data sources in questions, but as I read here this is not currently supported.
We are however in the process of putting our data in a warehouse solution like big query, so it seems from the above thread that this will allow us to combine the data sources in big query and then join these in metabase.
We would like to keep the different data sources as different data sets in Big Query. However looking at the bigquery documentation for metabase, it seems data sets are added separately, technically again being different data sources to metabase even if they both come from big query.
My question now is, will it be possible to join these two datasets, which are different sources in metabase but still both from big query, or will I run into the same problems that I have when trying to combine two raw data sources? This questions suggests that it will be the same issue.
If this route is also not possible for combining the data, how could I do it without combining the data beforehand in one dataset? Or is that the only option?