Multiple DataSources at same time

Diksha 2016-12-19 10:28:56 UTC #1

Can i join tables from PostGres and BigQuery in one big query?

How do I query tables from two data sources?

arikfr 2016-12-19 21:22:34 UTC #2

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.

mat 2016-12-21 10:25:10 UTC #3

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

lloydw 2017-01-12 02:59:24 UTC #4

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

James.gx_Chen 2017-03-09 07:14:07 UTC #5

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