Firstly you need to get the Server Hostname, Port and HTTP path from your databricks instance. Click on 'SQL Warehouses' in Databricks, then select the correct cluster and select connection details. Here you can get this info.
Then you need to generate an access token for Alteryx to use. In databricks click on your initial top right, select settings. Select the developer tab and manage next to Access Tokens. Hit generate new token. If this functionality is disabled, you will need someone to enable it for you. Be sure to copy the token and save it somewhere - it will be hidden once the dialog is closed. You can call the token anything you like, but make it something you can remember in case you need to revoke it later! You also have the option to set a token lifetime. The default value is 90 days, but you can also change it to 0, i.e. “never expire”.
With these details you can then fill in the driver set up.
Data Source name and description are free-text. Note the data source name will be part of the Alteryx data source name.
Ensure ‘Spark 1.1 and later’ type is selected.
Enter the hostname and port details saved from the cluster.
Ensure OAuth 2.0 is selected as the authentication mechanism.
Select OAuth Options, HTTP Options and SSL Options to open the dialog to ender further details as below.
Under OAuth Options select Token Passthrough as the authentication method and paste the Access Token saved from the cluster connection details. In the Password Options menu under the Encryption Options button, select All users of this Machine
Under HTTP Properties paste the HTTP Path saved from the cluster connection details.
Under the SSL Options ensure the Enable SSL option is checked and hit OK.
Hit Test to check your connection settings before clicking OK to finalise.
.png){kind=link}
