Joining druid datasources?

[MTShannon]

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if any
• I have reproduced the issue with at least the latest released version of superset
• I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

Expected results

Like the title states, is it possible to combine two druid datasources to use in a visualization? I've read that you can use views to join tables, but I couldn't find anything regarding Druid datasources.

Thanks

[ahsanshah]

I dont believe you can do "joins" per se in Druid. However, these may be potential options to consider:

1. You can always use slices across Druid datasources on a dashboard and having a common Dimension Column name will allow filtering across those sources

2. Superset recently has support for Multi-Line Chart which allows overlay of line charts which can indeed be across Druid data sources assuming a common Time Grain.

3. Annotations across 2 charts. this is similar to Fix documentation #2 but down side is that you cannot filter across the annotation as far as I am aware.

If you really do need tight integration you would have to either do it in the ETL pre-Druid ingestion or perhaps customize the SQL Alchemy engine to meet your needs.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.