Databricks Connectivity from Aperture Data studio

Uma Devi K

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

Josh Boxer

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).

https://docs.databricks.com/aws/en/integrations/jdbc-oss/configure#authenticate

Once you have that working, you will want to configure the custom driver json file to ensure the connection secret is hidden.

https://docs.experianaperture.io/data-quality/aperture-data-studio/configuration/configure-external-systems/#thirdpartydrivers~jdbc-databases

Similar to this post regarding oauth and Salesforce

https://community.experianaperture.io/discussion/1290/connecting-to-salesforce-with-oauth2

Uma Devi K

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

Josh Boxer

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=1