Add a druid cluster as a SQL database in Apache Su

问题:

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?

回答1:

Follow the steps below

1. You need to use latest version of pydruid for enabling sqlalchemy support. For me pydruid 0.4.1 is working fine.

2. On Superset, in the Databases section you need to provide the SQLAlchemy URI druid://XX.XX:8082/druid/v2/sql/using a broker ip/host.

3. Third thing you need to do is to enable druid.sql.enable=true on broker.

I hope this will help you.