Need help with multiple data sources where one has huge data set and other is a small set

Issue Summary

A summary of the issue and the browser/OS environment in which it occurs.

Technical details:

  • Redash Version: v8.0.0
  • Browser/OS: Firefox / Ubunutu
  • How did you install Redash: AWS AMI

Hi team,

I’m new to redash and have explored the tool and I really like. I have a question. Let’s say I have a query on data source 1 which has around 6k rows. and I want to join it on query 2 which has around 10 million rows. Now the important part here is I want to do something like in query_2 it should be “select * from table where id in (result of query_1)” Can I do this, if so how? I cannot do something with query_results as query_2 is huge and has 10 million rows.