Tableau#

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

JDBC connection#

Download the PrestoSQL JDBC driver for your specific version of PrestoSQL 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

Do not store more than one PrestoSQL 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 PrestoSQL 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 PrestoSQL 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 PrestoSQL 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 PrestoSQL has authentication enabled.

The Tableau ODBC documentation contains more information.