Connecting Zeppelin to Dremio

#1

Hi Guys,

has anyone been able to configure Zeppelin’s generic JDBC driver to work with Dremio? Any examples?

0 Likes

#2

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

4 Likes

#3

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.

0 Likes