You can make a Presto connection using either a direct connection or a reverse SSH tunnel connection.
To set up an SSH tunnel connection, please see our Tunnel Connection instructions. Once the tunnel is set up, add a new Presto data source in Chartio via Data > +Add Data Source.
Form requirements for both connection types:
- Hostname or IP (Direct Connection only)
- Database Port (Direct Connection only)
- Database Username (Direct Connection only)
You can find a list of catalogs in the etc/catalog directory of your Presto installation. Catalogs will each have their own file with the extension .properties.
- Schema Name
In the etc/catalog directory, find your Catalog. Open its .properties file to locate schema information.
- SSH public key (Tunnel Connection only) Your public key is required to authorize Chartio to connect to your Presto database. Locate it on your Presto server and paste it into the Chartio connection form.
For more information, please see the Presto Documentation.