Add a druid cluster as a SQL database in Apache Superset

Question

I currently connect to the druid cluster through the druid connector in Apache Superset. I heard that SQL can be used to query druid. Is it possible to point my SQL database connection to druid?

Answer 1

i was really struggling with this one... in my case, i am running on my mac. druid is installed directly and superset is running in docker (using the docker-compose setup).

the key is that localhost in the superset docker container doesn't point at the host, but instead at the docker container.

when i changed the superset datasource to this, it worked...

druid://host.docker.internal:8082/druid/v2/sql/