Using Dremio JDBC drivers with Maven

Question:

What dependencies do I need, to include Dremio JDBC jars in my Maven project?

Dremio Legacy JDBC Driver

To include the jars for the legacy JDBC driver, add the following to the relevant sections of your maven settings.xml

<repositories>
        <repository>
            <id>dremio-free</id>
            <url>https://maven.dremio.com/free/</url>
        </repository>
</repositories>

  <dependency>
      <groupId>com.dremio.distribution</groupId>
      <artifactId>dremio-jdbc-driver</artifactId>
      <version>24.0.0-202302100528110223-3a169b7c</version>
  </dependency>

The available versions can be found here : https://download.dremio.com/jdbc-driver/ and it is recommended to use the version that corresponds to the version of Dremio you are using.

Arrow Flight JDBC Driver

The Arrow Flight JDBC driver is an Apache project. To include it in your project, add the following dependency:

<dependency>
    <groupId>org.apache.arrow</groupId>
    <artifactId>flight-sql-jdbc-driver</artifactId>
    <version>14.0.1</version>
</dependency>

The full list of versions can be found here:

https://mvnrepository.com/artifact/org.apache.arrow/flight-sql-jdbc-driver

It is recommended to use the latest version of the driver available.