Hi All,
We are establishing a connection from Denodo to Databricks. During the development phase, we utilized a personal access token associated with developer account. However, this approach is not considered a best practice for production environments. Therefore, we intend to connect using a Service Principal OAuth token. Below are the parameters necessary for the connection; despite consulting the documentation, we have been unable to establish a successful connection.
Current configuration:
We are inputting the following parameters 1)jdbc url path : provided jdbc path from the databricks cluster 2) for the token endpoint: the Workspace URL is set as the token endpoint, 3) the Client Identifier is defined as the Resource Client ID, 4)and the Client Secret is given as the Resource Client Secret.
Furthermore, we have tried using our user credentials, which include the User Identifier and User Password, along with the Service Principal ID and Secret, because there are no applicable methods available for this issue. The scope is configured to encompass "all-apis".
We attempted several options, but we cannot connect the token from Denodo to Databricks. Please share your helpful suggestions on this.
