Connecting to Presto
Concept Information
Presto is an open source SQL query engine to run interactive analytic queries against different data sources. You can use the Presto data connector to import your company's Presto data.
Before you start
To connect to Presto, you must gather the following:
- user name and password
- the server's host name or IP address
- the correct connection port
- the correct authentication scheme
For help gathering the connection prerequisites, contact the Presto administrator in your organization. If your administrator cannot help you, you or your administrator should contact Presto Support.
Create a Presto connection
- From the Analytics main menu, select Import > Database and application.
- From the New Connections tab, in the ACL Connectors section, select Presto.
Tip
You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.
- In the Data Connection Settings panel, enter the connection settings and at the bottom of the panel, click Save and Connect.
You can accept the default Connection Name, or enter a new one.
The connection for Presto is saved to the Existing Connections tab. In the future, you can reconnect to Presto from the saved connection.
Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from Presto, see Working with the Data Access window.
Connection settings
Basic settings
Setting | Description | Example |
---|---|---|
User | The Presto user account to authenticate against the Presto server. | |
Password | The password used to authenticate the user with the server. | |
Server | The host name or IP address of the Presto REST server. | |
Port | The port for the Presto REST server. | 8080 |
Catalog |
The name of the catalog to use for all requests against the server. If this value is not set, the driver will retrieve the available catalogs from the Presto server. |
|
Auth Scheme | Specifies the authentication scheme that the driver uses. The options available are as follows:
|
|
Kerberos KDC |
The Kerberos Key Distribution Center (KDC) service used to authenticate the user. If the Kerberos KDC is not specified, the driver will attempt to detect this property automatically from the KRB5 Config File or the Domain Name and Host. |
|
Kerberos Realm | The Kerberos Realm used to authenticate the user with the Kerberos Key Distribution Service (KDC). | |
Kerberos SPN |
The Service Principal Name (SPN) for the Kerberos Domain Controller. If the SPN on the Kerberos Domain Controller is not same as the URL that you are authenticating to, you can use this property to set the SPN. |
|
Kerberos Keytab File | The Keytab file that contains your pairs of Kerberos principals and encrypted keys. | |
Use SSL | Specifies whether SSL is enabled or not. |
Advanced settings
Setting | Description | Example |
---|---|---|
Limit Key Size | The maximum length of a primary key column. | 255 |
Map To Long Varchar | This property controls whether a column is returned as SQL_LONGVARCHAR or not. | -1 |
Map To WVarchar | This property controls whether string types map to SQL_WVARCHAR instead of SQL_VARCHAR. | |
Pseudo Columns |
This property indicates whether to include pseudo columns as columns to the table. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". |
|
SSL Server Certificate |
The certificate that must be accepted from the server when connecting using SSL. You can provide any of the following:
Any other certificate that is not trusted by the machine is rejected. |
|
Query Passthrough | When you enable this option, all queries are passed directly to Presto. | |
Convert Datetime To GMT |
Converts datetime fields to GMT time zone during import. If this option is disabled, the datetime value is converted to the operating system time zone of the system running Analytics. |
|
Proxy Authentication Scheme |
Specifies the authentication scheme to authenticate to the Proxy Server. The options available are as follows:
|
BASIC |
Proxy Auto Detect | Specifies whether to use the system proxy settings or not. The value set for this option takes precedence over other proxy settings. So, if you want to use custom proxy settings, disable this option. | |
Proxy User | The user name to authenticate to the Proxy Server. | |
Proxy Password | The password to be used with the Proxy User to authenticate to the Proxy Server. | |
Proxy Server | The hostname or IP address of a proxy to route HTTP traffic through. | |
Proxy Port | The TCP port the Proxy Server is running on. | |
Proxy SSL Type |
The SSL type to use when connecting to the ProxyServer proxy. The options available are as follows:
This option is enabled only when you provide the value for the Proxy Server. |
AUTO |