Add a Presto database connection

You can add a connection to a Presto database using ThoughtSpot DataFlow.

Follow these steps:

  1. Click Connections in the top navigation bar.

  2. In the Connections interface, click Add connection in the top right corner.

  3. In the Create Connection interface, enter the Connection name, and select the Connection type.

  4. After you select the Presto Connection type, the rest of the connection properties appear.

    • Connection name
      Name your connection.

    • Connection type
      Choose the Presto connection type.

    • Host
      Specify the hostname or the IP address of the Presto system

    • Port
      Specify the port associated with the Presto system

    • User name
      Specify the user id that will be used to connect to the Presto system. This user must have necessary privileges to access the data in the databases.

    • Authentication type
      Based on the security protocol you use to connect to the instance, select the authentication type and provide details.

    • SSL key store path
      Specify the trust store path, generated by the server

    • SSL key store password
      Specify the password for the key store. The client generates this while generating the key store file

    • Ldap password
      Provide LDAP password to connect.

    • Kerberos remote service name + Hostname of the Kerberos server. Required to generate the krb.conf file

    • User principal
      To authenticate via a key-tab, you need the user principal associated with the key-tab. You can configure this when enabling Kerberos.

    • Kerberos config
      A Kerberos config explains the configuartion details used to connect to Kerberos authentication server.

    • User keytab
      To authenticate via a key-tab, you must have the supporting key-tab file that the Kerberos Admin generates.

    • Catalog name
      Specify the catalog file name

    • Schema name
      Specify the schema name of a database

    • JDBC options + Specify the options associated with the JDBC URL.

    See Connection properties for details, defaults, and examples.

  5. Click Create connection.