📘Introducing SQL Notebooks: Tell stories using data.Read more →

Connecting to Presto

  1. Click Manage Connections in the top center of the app. Screenshot of managing your connections

  2. Click New Connection in the Manage Connections modal in PopSQL. Screenshot of creating a new connection in PopSQL

  3. For Nickname, enter something a descriptive name for your connection, like Acme Production.

  4. For Type, choose Presto.
  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 Catalog, enter the name of your catalog. A Presto catalog contains schemas and references a data source via a connector (learn more).
  8. For Schema, enter the name of your schema.
  9. For Username and Password, enter the username and password for Presto. These are optional.
  10. Hit Connect and you're all set! Screenshot of a sample Presto connection in the New Database Connection modal in PopSQL

Happy querying! 🍭

Ready for a modern SQL editor?