Connecting to Presto

  1. Open the connections page in preferences, see managing connections for more information.
  2. Click the Add new Connection button at the top of the connections page.
  3. Select Presto from the list.
  4. Give a Connection name for your own internal reference.
  5. For Hostname, enter the hostname of your database server.
  6. For Port, use the default 8080, or enter the port used by your server.
  7. For Username and Password, enter the username and password for Presto. These are optional.
  8. For Catalog, enter the name of your catalog. A Presto catalog contains schemas and references a data source via a connector (learn more).
  9. For Schema, enter the name of your schema. This is optional.
  10. Toggle connection type for direct or cloud.
  11. Share the connection with your team.
  12. Configure SSH and SSL settings. These are optional.
  13. Hit Connect and you're all set!

Screenshot of a sample Presto connection in the New Database Connection modal in PopSQL

Happy querying! 🍭

Cookie settings