Can i join tables from PostGres and BigQuery in one big query?
This is a feature that currently only available in the hosted version of Redash. We do plan to open source it, but currently no ETA.
Depending on the size of the data you want to join, you could use python as a datasource to join the result of 2 separate queries across 2 different datasources.Arikfr made an example here: https://gist.github.com/arikfr/be7c2888520c44cf4f0f
I've created a simple Python object that makes combining results from multiple data source really easy, it's available here if you're interested - https://gist.github.com/lloydw/1e5a4a29eddd8c4d850c1f58f4bd51b2