Databricks Connectivity from Aperture Data studio
Hi Team,
We are trying to connect Databricks workspace from Aperture Data studio.But our platform team is not suggesting to use PAT token for data bricks connectivity.
Kindly let me know if anyone is connecting Databricks using the service principal Oauth from Aperture Data studio.
if so kindly share the details.
Regards
Uma
Comments
-
Hello
Yes you should be able to use oauth to connect to Databricks using their JDBC driver by adding an extra connection string parameter(s).
Once you have that working, you will want to configure the custom driver json file to ensure the connection secret is hidden.
Similar to this post regarding oauth and Salesforce
0 -
Hi @Josh Boxer ,
I have tried to connect Databricks workspace using Oauth2 from Aperture data studio and getting the below error
Caused by: com.databricks.client.jdbc42.internal.apache.thrift.transport.TTransportException: No access token or refresh token provided
Connection string: jdbc:databricks://<server-hostname>:443;httpPath=<http-path>;AuthMech=11;Auth_Flow=0;OAuth2ClientId=xxx;OAuth2Secret=xxx;
Could you please check and let me know if any additional parameters should be added.
Regards
Uma
0 -
Not entirely sure and it might be a question to ask Databricks as this error is being returned by their driver. Are you using the latest version?
Looking at their documentation they do mention two other parameters:transportMode=http
ssl=10
