- Navigate to File > New > Driver, to open Data Sources and Drivers window
- In the new window change Name field of the driver to Avatica Apache Druid (or anything else you want to recognize it)
- Go to Driver Files hit + button and upload all the jar files which can be found in the jars folder of my Github repo
- Select org.apache.calcite.avatica.remote.Driver in the Class drop down menu
- Add a URL template, name it default and set value to:
jdbc:avatica:remote:url=http://{host::localhost}:{port::8082}/druid/v2/sql/avatica/- Go to tab Options and there in the Other section select Generic SQL from the drop down menu
- Apply to save Driver
- Navigate to File > New > Data Source > {Druid Driver name}
- Change host and port if needed (default port is set to 8082 because it is the default plaint text port of Broker node)
- Test connection
- Apply to save Data source