![Earth firmament](https://loka.nahovitsyn.com/258.jpg)
The main drawback of this workaround is the fact that by using Generic SQL dialect autocomplete is not available and keyword highlighting is limited to classic functions such as count.
DATAGRIP SQL DRIVER
I haven’t yet tried to connect to a Broker node using TLS but I think it won’t be a problem as it is possible while using the Avatica driver with Tableau. Go to tab Options and there in the Other section select Generic SQL from the drop down menu.Add a URL template, name it default and set value to:.Select .remote.Driver in the Class drop down menu.Go to Driver Files hit + button and upload all the jar files which can be found in the jars folder of my Github repo.In the new window change Name field of the driver to Avatica Apache Druid (or anything else you want to recognize it).
DATAGRIP SQL DRIVERS
![datagrip sql datagrip sql](https://cdn.appmus.com/images/ee802159ff8ef68eceb7f7a35195c47b.jpg)
Once you have a connection then you can start writing out the scripts that define your database tables and other objects. You can get a connection to SQLite going very easily though, and unlike other databases it doesn't require a server per se (or to be more correct the server is self contained in the driver). DataGrip is still a great tool for learning SQL, but there's generally some additional setup involved in getting a server running that they simply don't cover.
![Earth firmament](https://loka.nahovitsyn.com/258.jpg)