[en] Databricks Azure OAuth Authentication

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

[en] Select Save.

[en] To link the credentials select + Connect Credential.

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

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

1. [en] For AzureOAuth with Simba you need

   1. [en] 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. [en] AzureOAuthTokens. You can choose existing token or Create New Credential for OAuth Tokens. For a new credential fill in the Credential Name.

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

   1. [en] For a new credential fill in the Credential Name.

[en] Select Create and Link.

[en] Select the Connect button.

[en] Sign in on the external browser window.

[en] Choose the DSN-less Technology from the drop down menu.

[en] Fill in the information:

1. [en] Data Source Name,

2. [en] Server (address of your cluster),

3. [en] Port,

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

[en] Select Save.

[en] To link the credentials select + Connect Credential.

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

1. [en] For AzureOAuth with Simba you need

   1. [en] 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. [en] AzureOAuthTokens. You can choose existing token or Create New Credential for OAuth Tokens. For a new credential fill in the Credential Name.

[en] Select Create and Link.

[en] Select the Connect button.

[en] Sign in on the external browser window.

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

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

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

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

[en] Fill in the Connection Name.

[en] To configure Read connection

1. [en] Select Setup Connection.

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

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

4. [en] Follow steps from Connection with DSN and Connection without DSN sections.

[en] To configure Write connection

1. [en] Choose staging method from the drop down menu.

2. [en] Select Setup Connection.

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

4. [en] Follow steps from Connection with DSN and Connection without DSN sections.

   注意

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

[en] Select Apply and OK.

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

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

[en] Fill in the Table Name and select the canvas.