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

Connecting to Databricks

  1. Click Manage Connections in the top center of the app.
  2. Click New Connection in the Manage Connections modal in PopSQL. alt text
  3. For Nickname, enter something a descriptive name for your connection, like Acme Production.
  4. For Type, choose Databricks.
  5. For Hostname, enter your Databricks workspace's url (for example dbc-a2c61234-1234.cloud.databricks.com).
  6. For Port, use the default 443, or enter the port used by your server.
  7. For HTTP Path, enter HTTP Path (you can find in your cluster settings: Advanced Options -> JDBC/ODBC, for example sql/protocolv1/o/4337956624071234/1234-123456-pane123).
  8. For Database, enter the name of your database (most likely default).
  9. For Username and Password, enter the email and password or use personal access token.
  10. Hit Connect and you're all set!

alt text

Happy querying! 🍭

Ready for a modern SQL editor?