Download Apache Pinot JDBC Driver

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

About the Apache Pinot JDBC driver

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

The Apache Pinot JDBC driver

Apache Pinot is a distributed, real-time OLAP datastore built for low-latency analytics on large-scale event streams. It is designed to ingest data from sources like Apache Kafka and query it with sub-second latency, making it popular for user-facing analytics applications. Pinot's columnar storage and inverted indexes enable high-throughput, high-concurrency analytical queries.

The Apache Pinot JDBC URL

• Required File(s): pinot-jdbc-client-xxx.jar
• Java Driver Class: org.apache.pinot.client.PinotDriver
• JDBC URL: jdbc:pinot://{HOST}:{PORT}
• Website: Apache Pinot

Connect to the Pinot Broker on port 9000. The JDBC driver is part of the Pinot client distribution and can be obtained from the Apache Pinot release artifacts or Maven Central. Authentication and TLS settings can be configured via additional JDBC URL parameters.

DbSchema and Apache Pinot

DbSchema connects to Apache Pinot via the Pinot JDBC driver, letting teams visualize real-time OLAP schemas, explore segment contents, and write low-latency analytical SQL queries through an interactive editor.