Databricks Azure OAuth Authentication

Choose the DSN Technology, fill in the Data Source Name and choose the prepared OAuth DSN.

Select Save.

To link the credentials select + Connect Credential.

You can choose User name and password or OAuth as an Authentication Method.

You can choose AzureOAuth with Simba, AzureOAuth with Simba(Alteryx Application), No Credentials, Username, or Username and password as an Authentication Method.

1. For AzureOAuth with Simba you need

   1. AzureOAuth Application Credentials. You can choose existing one or Create New Credential. For a new credential fill in the Credential Name, Tenant ID, Client ID, and Client Secret. All you can find on Microsoft Azure application registration page.

   2. AzureOAuthTokens. You can choose existing token or Create New Credential for OAuth Tokens. For a new credential fill in the Credential Name.

2. AzureOAuth with Simba(Alteryx Application) you can Create New Credential or choose an existing one.

   1. For a new credential fill in the Credential Name.

Select Create and Link.

Select the Connect button.

Sign in on the external browser window.

Choose the DSN-less Technology from the drop down menu.

Fill in the information:

1. Data Source Name,

2. Server (address of your cluster),

3. Port,

4. HttpPath (listed in your cluster Configuration - Advanced options).

Select Save.

To link the credentials select + Connect Credential.

You can choose AzureOAuth with Simba and AzureOAuth with Simba(Alteryx Application) as an Authentication Method.

1. For AzureOAuth with Simba you need

   1. AzureOAuth Application Credentials. You can choose existing one or Create New Credential. For a new credential fill in the Credential Name, Tenant ID, Client ID, and Client Secret. All you can find on Microsoft Azure application registration page.

   2. AzureOAuthTokens. You can choose existing token or Create New Credential for OAuth Tokens. For a new credential fill in the Credential Name.

Select Create and Link.

Select the Connect button.

Sign in on the external browser window.

Select Manage Connections in the Data Stream In Configuration - Connection Name drop down menu.

Select the Databricks datasource on the In-DB manager pop-up window.

You can select New to create a new connection or choose to use an existing one.

For the new connection, select the Use Data Connection Manager (DCM) check box.

Fill in the Connection Name.

To configure Read connection

1. Select Setup Connection.

2. Select + Add Data Source on the Connection Manager window.

3. When adding a Data Source, you can choose the connection with or without DSN.

4. Follow steps from Connection with DSN and Connection without DSN sections.

To configure Write connection

1. Choose staging method from the drop down menu.

2. Select Setup Connection.

3. Select + Add Data Source on the Connection Manager window.

4. Follow steps from Connection with DSN and Connection without DSN sections.

   Note

   Note that for a DSN bulk loading, you need to manually specify Databricks server address when adding a new datasource.

Select Apply and OK.

Sign in on the external browser window (you may be prompted to authenticate twice for both Read and Write connection).

Select Create New Table in the Data Stream In Configuration - Creation Mode drop down menu.

Fill in the Table Name and select the canvas.