How do I top up my Presto card

Presto

This article describes how to connect Tableau to a Presto database and how to set up the data source.

Tableau can be connected to Teradata's Presto 141t and to local Presto and Amazon EMR Presto instances for Presto version 0.148.

Note: As of 2020.3, the Presto connector will be JDBC-based.

requirements

First, collect this connection information:

  • Name of the server hosting the database that you want to connect to

  • Catalog

  • Authentication method:

    • User name

    • LDAP

      Note: LDAP authentication is available for Tableau Desktop version 10.3.2 and higher.

  • Credentials: Your choices depend on the authentication method you choose and can include:

  • Do you want to connect to an SSL server?

  • (Optional) Initial SQL statement that is run every time Tableau connects

Driver required

A driver is required for this connector to communicate with the database. The required driver may already be installed on your computer. If the driver is not installed on your computer, Tableau will display a message in the connection dialog with a link to the Download Driver page (Link opens in a new window). There you will find driver links and installation instructions.

Establishing the connection and setting up the data source

  1. Start Tableau and under Connect, select Presto. A comprehensive list of data connections is displayed when you select More under With a server. Then do the following:

    1. Enter the name of the server you want to connect to.

    2. Enter the catalog name.

    3. Select the authentication method: Username or LDAP and enter the requested credentials.

      When connecting to an SSL server, select the Require SSL check box.

    4. (Optional) Select Initial SQL Dates to specify an SQL command to run at the start of every connection, such as: For example, when you open a workbook, refresh an extract, sign in to Tableau Server, or publish content to Tableau Server. For more information, see Executing Initial SQL.

    5. Select Sign In.

      If Tableau cannot connect, verify that your credentials are correct. If you still cannot connect, the computer cannot find the server. Contact your network administrator or database administrator.

  2. On the data sources page, do the following:

    1. (Optional) Select the default data source name at the top of the page, then enter a unique data source name to use in Tableau. For example, you can use a data source naming convention to help other users determine which data source to connect.

    2. Select the search icon from the Scheme drop-down list or type the name of the scheme in the text box, select the search icon, and then select the scheme.

    3. Select the search icon from the Table text box, or type the table name, select the search icon, and then select the table.

    4. Drag the table onto the work area, then click the sheet tab to start your analysis.

      Use custom SQL to connect to a specific query rather than the entire data source. For more information, see Connect to a Custom SQL Query.

Sign in to a Mac

If you are using Tableau Desktop on a Mac, enter a fully qualified domain name (for example, "mydb.test.ourdomain.lan") instead of a relative domain name (for example, "mydb" or "mydb.test").

Alternatively, you can add the domain to the list of search domains for the Mac computer so that you only need to provide the server name to connect. To update the list of search domains, go to System Preferences> Network> Advanced, then open the DNS tab.

See also

  • One-way SSL for JDBC connections - configure the trust relationship for a self-signed or CA certificate when using one-way SSL with a JDBC connector.