Hi everybody,

I recently learned from Superset Upstream that the suggested way to query
Druid is using the SQLAlchemy connector, not the Druid one (that is
"deprecated"). I digged a little bit more about this and I found the
following:

- Druid Analytics supports SQL querying on the brokers, so it was a matter
of adding a new "database" called "Druid Analytics SQL" to Superset.
- "Druid Analytics SQL" can be used for data querying and exploration in
the SQL Lab (feel free to test it!).
- Using SQLAlchemy should be more quick/convenient since we wouldn't need
to define mapping for Druid datasources manually (need to better
investigate this but I am reasonably sure).

Moving all the charts already in Superset to the new database/datasource is
probably a ton of work, and we are not really in a hurry (the "deprecated"
above means that they still support it but a bug to that code will be
considered not a blocker), but what I'd ask it to start using it and see if
there are pros/cons in your daily workflows.

I created a task to report thoughts/suggestions/bugs/etc.. to avoid
spamming too many people: https://phabricator.wikimedia.org/T249681

Thanks!

Luca
_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics

Reply via email to