Hi Guys,
has anyone been able to configure Zeppelin’s generic JDBC driver to work with Dremio? Any examples?
Hi akikax,
yes, it is possible by using the default JDBC interpreter.
You have to download the Dremio JDBC driver and save it on the server where Zeppelin is running, then edit your jdbc interpreter adding the following information:
On the dependencies, add the path where you downloaded the driver, for example:
/usr/hdp/current/zeppelin-server/lib/dremio-jdbc-driver-2.1.6-201809161906440178-edb5b4d.jar
then add the following information:
dremio.driver=com.dremio.jdbc.Driver
dremio.url=jdbc:dremio:zk=zk1.local,zk2.local,zk3.local:2181
dremio.user=dremioadmin
dremio.password=dremiopassword
Then save and restart the jdbc interpreter. Now you can create a new notebook, associate the jdbc interpreter to the notebook and execute query on dremio using %jdbc(dremio)
Hope this helps
5 Likes
Hi Horadrim,
Your instructions worked perfectly. Thanks a lot for sharing.
For anyone trying to do the same, just follow Horadrim’s instructions they are complete and correct, nothing to add from my end.