Introduction
The article will cover the steps to establish an OAuth integration with Databricks.
OAuth integration is recommended for improved data security and to simplify users' access to data.
Using an OAuth integration with the Astrato live-query engine means that all security and access rules defined in Databricks are automatically inherited by Astrato; there is no need to resecure the data in Astrato.
Creating New Integration
In Astrato, navigate to the Administration section and select Enterprise Connection
Navigate to the Access Integration tab and click the New Integration button.
Select Databricks and leave the screen open.
Databricks Setup
Navigate to your Databricks Warehouse and under the connection detail tab, find the hostname and HTTP path. Make note of these for later use.
Click the workspace name in the top-right corner, then click Manage account.
Click on the settings tab
Navigate to app connections, and create a connection using the Add connection button.
Fill out the form:
Application name - Meaningful Name
Redirect URL - The Astrato redirect URL is located in the enterprise connection Configuration tab, opened in the first phase.
and check the box next to All APIs.
Set the validity period for the token and the refresh token.
Click Add.
Copy the Client ID and Client Secret.
They will be needed later in the Astrato part.
Astrato Setup
In the open integration that was opened at the start of the process, navigate to the Setup tab.
Fill the form and click the Create button.
Click the Verify Connection at the top.
When verification is successful, this message will appear.
To use the integration, navigate to the Data & AI and create a new data connection to Databricks
Select the OAuth option for authentication.
