3.5. Tableau#

Tableau is a popular analytics tool that can be used to run queries in Presto. It has powerful data visualization capabilities. You can connect Tableau to Presto with JDBC or ODBC. The recommended connection method is using the JDBC driver.

JDBC connection#

Download the Presto JDBC driver for your specific Presto version with the link to the binary .jar file on the download page.

Place the file in the Tableau drivers directory. On MacOS, this directory is ~/Library/Tableau/Drivers. You can find more information about the JDBC driver usage in the supporting Tableau JDBC documentation.

Warning

You should not store more than one Presto JDBC driver in this directory.

With the driver in place you can start Tableau. On the main page, select Other Databases (JDBC) and provide the connection parameters. Table

  • URL: jdbc:presto://presto.example.com:8080/

  • Dialect: SQL92

  • Username: <username>

The URL parameter needs to point to your Presto server hostname and port. Ensure the dialect is set to SQL92.

Select Sign In to establish the connection. You are quoted for a password, if Presto has authentication enabled.

If you need to set additional connection properties that are not included in Tableau’s connection wizard, you can create a properties file.

ODBC connection#

As first step, download and install the Starburst ODBC Driver. The ODBC driver for Presto included with Tableau is not supported.

Open Tableau and begin the ODBC configuration. On Tableau’s startup page, select Other Databases (ODBC):

  • Driver: Starburst Presto ODBC Driver

  • Username: <username>

  • String Extras: Driver=Starburst Presto ODBC Driver;Catalog=<catalog>;Host=<host>;Port=<port>;

Note that “String Extras” supports any of the ODBC connection properties from the Starburst ODBC driver.

Select Sign In to establish the connection. You are quoted for a password, if Presto has authentication enabled.

The Tableau ODBC documentation contains more information.