Connection Refused to Dremio

Driver Development
21

Thanks for your response.
Anyway you could share your current unachieved work, we would unify our efforts to make it work as expected.
I’ve already done a dremio connector for superset, in python, why not a one for metabase in clojure !

22

Thanks for your effort @reydavid, I guess to make this driver (Matabase -> Dremio) we need try deferents versions of JDBC driver ( https://download.dremio.com/jdbc-driver/ ) the string to connect is like the dbeaver ( https://docs.dremio.com/client-applications/dbeaver.html ).

What do you think?

check here!
https://github.com/metabase/metabase/wiki/Writing-a-Driver:-Packaging-a-Driver-&-Metabase-Plugin-Basics

23

Hi @arsenikstiger and @stanleydf
The 2 gotchas I can share with you regarding the Dremio driver plugin are the driver version you need to use and the proper connection string.

  1. The Dremio JDBC driver you need to use is version v3.0.6. Any version above that might fail and drive you nuts figuring out why.
  2. In Metabase, you need to override the necessary “sql-jdbc.conn/connection-details->spec” method in the dremio.clj Clojure file. An operational override of this method that I constructed is below:

(defmethod sql-jdbc.conn/connection-details->spec :dremio
[_ {:keys [user password host port source-name ssl]
:or {user “dbuser”, password “dbpassword”, host “localhost”, source-name “dremioSource”}
:as details}]
(-> {:applicationName config/mb-app-id-string
:host host
:password password
:classname “com.dremio.jdbc.Driver”
:connection-uri (str “jdbc:dremio:direct=” host “:” port)
:source source-name
:loginTimeout 10
:user user
:encrypt (boolean ssl)
:sendTimeAsDatetime false}
(merge (when port {:port port}))
(sql-jdbc.common/handle-additional-options details, :seperator-style :semicolon)))

Good luck!

24

I updated this issue five minutes ago :