Download Dremio JDBC Driver

Download the Dremio JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Dremio JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Dremio. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Dremio driver uses its own syntax — see the connection details below.

The Dremio JDBC driver

Dremio is a lakehouse platform that provides high-speed SQL query execution directly on cloud object storage such as S3, ADLS, and GCS without data movement. It acts as a semantic layer over heterogeneous data sources, enabling self-service analytics with fast reflections and data virtualization. Dremio supports Apache Arrow Flight SQL for high-throughput data transfer.

The Dremio JDBC URL

• Required File(s): dremio-jdbc-driver-xxx.jar
• Java Driver Class: com.dremio.jdbc.Driver
• JDBC URL: jdbc:dremio:direct={HOST}:{PORT}
• Website: Dremio

Connect to the Dremio coordinator on port 31010 (Arrow Flight SQL port). Authentication uses Dremio username and password. For ZooKeeper-based discovery in distributed mode, use jdbc:dremio:zk=zkhost/dremio as the connection URL instead.

DbSchema and Dremio

DbSchema connects to Dremio using the Dremio JDBC driver, enabling visualization of virtual dataset schemas from S3, ADLS, and other data sources, and SQL query execution against Dremio's lakehouse engine through the built-in SQL editor.