Add a Presto database connection
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.
See Connection properties for details, defaults, and examples.
- 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.
- Query engine
-
Specify the type of query engine to connect to this instance.
- 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.conffile - 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 configuration 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.
-
Click Create connection.
