You can add a connection to a Presto database using ThoughtSpot DataFlow.
Follow these steps:
-
Click Connections in the top navigation bar.
-
In the Connections interface, click Add connection in the top right corner.
-
In the Create Connection interface, select the Connection type.
-
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 thekrb.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.
- Connection name
-
Click Create connection.