Download Firebolt JDBC Driver

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

About the Firebolt JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Firebolt. 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 Firebolt driver uses its own syntax — see the connection details below.

The Firebolt JDBC driver

Firebolt is a cloud data warehouse engineered for sub-second analytics on large datasets, offering a fully managed, high-performance OLAP engine built on top of cloud object storage. It uses aggregating indexes and join indexes to dramatically accelerate repeated query patterns, making it well-suited for interactive analytics applications. Firebolt provides a familiar SQL interface and integrates with popular BI tools.

The Firebolt JDBC URL

• Required File(s): firebolt-jdbc-xxx.jar
• Java Driver Class: com.firebolt.FireboltDriver
• JDBC URL: jdbc:firebolt://{HOST}/{DB}
• Website: Firebolt

Firebolt uses HTTPS on port 443. Authentication requires a Firebolt service account client ID and client secret (or email/password for older versions). Specify the engine name as a parameter, for example: jdbc:firebolt://api.app.firebolt.io/mydb?engine=myengine.

DbSchema and Firebolt

DbSchema connects to Firebolt using the Firebolt JDBC driver, enabling visualization of cloud analytics schemas including aggregating and join indexes, and SQL query execution against Firebolt's high-performance OLAP engine.