Can i join tables from PostGres and BigQuery in one big query?
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
arikfr
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.
2 Likes
mat
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
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
How to query when combining multiple datasources in one query in the hosted version of Redash?
@arikfr