ODBC driver #

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

Typically the applications are Windows-based, or support ODBC driver usage on other operating systems. Using an applications with the ODBC driver generally follows the same steps.

Connection information #

Get the necessary connection information for your cluster.

Download and configure the driver #

Unlike the ODBC driver, the ODBC driver requires a license. Get a licensed copy of the driver installation package from the Starburst support team.

You can find more information in the ODBC driver reference documentation.

Typically you have to install the OBDC driver and add it to your application. Adding it to your application varies for each application. Some applications, such as Power BI include the driver. Refer to the documentation for details for your application.

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 ODBC connection are automatically configured in many applications, or can be seen and updated in an user interface dialog.

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.