Toad allows you to create a native Databricks connection, which provides you with a full-featured Object Explorer, Query Builder and SQL Editor.
Note: You must have a Simba Apache Spark ODBC Connector 2.8.2 (or later) installed before a native connection is created.
To install the Simba Apache Spark ODBC Connector
Download and install the ODBC Connector from the Databricks Web site.
Click 
Enter the connection information in the Create New Connection dialog.
Review the following for additional information:
| General Tab | Description |
|
Host |
Enter the server where the Databricks instance is hosted. |
|
Authentication |
Select the type of authentication to use for this connection. Toad offers two options:
|
|
Port |
The default port number is 443 |
|
HTTP Path |
Enter the endpoint used to route queries to the appropriate cluster or resource. |
|
Token |
Enter your authentication token |
|
Optional |
A connection can be made without providing this information |
|
Catalog |
Enter the name of the Catalog you would like to connect to |
Click Connect to save the connection and immediately connect to the database.
or
Click Save to save the connection without connecting to the database.
Notes:
The Enable Query Result Download checkbox, located in the Advanced tab, allows you to enable or disable the downloading of query results. Disabling this option can improve performance when working with large result sets.
To use Databricks native connections in Toad Data Point, Unity Catalog must be enabled in your Databricks workspace.
Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
