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.

Update 22/2/2018: the ability to run queries on query results (which allows joining data across multiple data sources) is available in the open source version since V3.

2 Likes

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

How to query when combining multiple datasources in one query in the hosted version of Redash?
@arikfr