@prasad vaze​ I don't use SSMS (not a Windows user), and I'm not even sure if it will work with Databricks. However, I did want to list the steps to get DBvisualizer to work:

1. Download Databricks' JDBC drivers and extract them on your computer
2. Start DbVisualizer and in Preferences > General > Driver Manager, add the folder where you extracted the driver to the search path. Click Ok to close the preferences dialog.
3. Click Tools > Driver Manager and add a JDBC (Generic) driver
4. Name the new driver "Databricks" and provide this JDBC URL: jdbc:spark://<workspace>:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/endpoints/<endpoint>
5. Driver class should be com.simba.spark.jdbc.Driver
6. In the left pane, add a new Connection. Settings format will (by default) be Database URL.
7. Enter this in Database URL: jdbc:spark://{{workspace}}:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/endpoints/{{endpoint_id}};
8. Replace the values of {{workspace}} and {{endpoint_id}}. workspace_id is just the DNS name of your workspace, and endpoint_id can be found in Databricks clicking in the left nav on SQL > SQL Endpoints > Connection Details. It's in the last fragment in the HTTP path field e.g. /sql/1.0/endpoints/{{workspace_id}}
9. In the same settings page in Databricks, click "Create a personal access token" (PAT) and copy the value
10. Back in DbVisualizer in the Connection page, set Database Userid to "token" and Database Password to the value of the PAT
11. Now you can connect!
12. Note that you may have to issue a "use <database_name>" statement before your query (in case you get a "table or view not found" error