I have two bigQuery data sources and would like to query from both data sources and combine into one chart.

I saw this post and knew that there’s possibility to do this in the hosted version of redash.
However, I still had hard time figure out how to do it.

Is this one of the feature of newer version or I have to modify the source codes?

4 Likes

I understand this is a very old forum post. But it still gets a lot of clicks and deserves an answer.

Yes, you can do this in Redash using the Query Results Data Source. The typical caveats about Redash performance apply. So if you need to join 100k+ rows of data across multiple BigQuery instances, you should use a proper data warehouse or ETL solution (and connect Redash to that!).

In many cases, however, the query results data source provides an adequate means of linking together data from multiple sources.

2 Likes