JDBC driver #

The Java Database Connectivity (JDBC) driver enables any application supporting a JDBC driver to connect to Starburst clusters. The application can then issue SQL queries and receive results.

Typically the applications are JVM-based, or support JDBC driver usage with a different mechanism. Using an applications with the JDBC driver generally follows the same steps.

Connection information #

Get the necessary connection information for your cluster.

Download and configure the driver #

Typically you have to download the JDBC driver and add it to your application.

Adding it to your application varies for each application. Refer to it’s documentation.

Some applications, such as DBeaver, automatically download and configure the driver.

Create the connection to the cluster #

With a configured driver you can now configure a connections to a cluster. Typically you only need the connection information. Other details such as the JDBC URL are automatically configured in many applications, or can be seen and updated in an user interface dialog.

If your application does not include these out of the box, simply check the reference documentation for the JDBC driver for the correct values.

Start querying #

The configured connection, can now be opened and you can start running queries.

For example, if you application allows you to write and run queries you can see what catalogs are available:

SHOW CATALOGS;

Many applications provide a user interface to see the list of catalogs, schema, tables and much more.

Next steps #

Now you can take advantage of the features of your application, and potentially learning more about the SQL support in Starburst.