Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

Connecting to Databricks

Note: PopSQL supports Databricks only as a cloud connection.

  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 Databricks from the list.
  4. Give a Connection name for your own internal reference.
  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 a personal access token.
  10. Share the connection with your team.
  11. Hit Connect and you're all set!

alt text

Happy querying! 🍭

Ready for a modern SQL editor?