Hey I'm trying to connect to Databricks using client id and secrets. I'm using JDBC 2.6.38.
I'm using the following connection url: jdbc:databricks://<server-hostname>:443;httpPath=<http-path>;AuthMech=11;Auth_Flow=1;OAuth2ClientId=<service-principal-application-id>;OAuth2Secret=<service-principal-oauth-secret>
But I'm getting the following error message:
Error encountered while running an operation in the data warehouse: [Databricks][JDBC](10100) Connection Refused: [Databricks][JDBC](11640) Required Connection Key(s): PWD; [Databricks][JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, CatalogSchemaSwitch, DecimalColumnScale, DefaultStringColumnLength, DelegationToken, DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, NonSSPs, PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, StripCatalogName, UseCustomTypeCoercionMap, UseNativeQuery
Is there a way I can connect to Databricks without using PWD?