Inbuilt Qubole Presto Connector (JDBC) - For Tableau Version 2020.3 or Later

Follow the instructions to configure Tableau using Inbuilt Qubole Presto Connector (JDBC):

A. Download Qubole JDBC Driver

  1. Download the latest Qubole JDBC driver. For more information, see JDBC Driver.
  2. Move the driver (jar) file to following location:
    • For Windows: C:\Program Files\Tableau\Drivers
    • For Mac: ~/Library/Tableau/Drivers
    • For Linux: /opt/tableau/tableau_driver/jdbc

B. Connect to Qubole Data Service (QDS)

Follow the instructions below to connect to QDS:

  1. After opening Tableau, navigate to the Connect menu. Under To a Server, select More….

  2. Click Qubole Presto and the Qubole Presto dialog box appears.

    ../../../../_images/tab-menu.png

  3. Enter the End Point, Catalog, Cluster Label, and Password in their respective fields.

    ../../../../_images/qub_presto.png

    Note

    • You can find the Password from QDS (Control Panel > My Accounts > click Show under the API Token column and copy it). To know more, see Managing Your Accounts.
    • EndPoint: Mention the EndPoint based on the region where you have the Qubole account. For more information, see Supported Qubole Endpoints on Google Cloud Platform (GCP). The EndPoint doesn’t require suffixes such as /api/xxx. For example, the EndPoint can be https://in.qubole.com.
    • How to add additional parameters? You should add the additional JDBC parameter with the EndPoint field value and use a semicolon (;) to separate them (Example: https://api.qubole.com;qds_bypass=true;LogLevel=6;LogPath=/tmp).

  4. Select Read uncommitted data check box to enable streaming results.

  5. Click Sign In to fire a query on the Qubole portal.

You have successfully connected to Qubole Data Service (QDS) via Inbuilt Qubole Presto Connector (JDBC).