Splunk DB connect fails to connect to Databricks

[mflpopescu]

Following guide Splunk DB Connect Guide for Databricks but when creating a connection to Databricks and trying to test it in Data Lab >> SQL Explorer, I'm getting error "Cannot get schemas"

This is the combo used (tried others as well but the error thrown is always the same) DB connect: 3.12.2 JDBC driver: 2.6 JAVA: JRE 11

Connection fails with the following errors in splunk/var/log/splunk/splunk_app_db_connect_server.log

ERROR c.s.d.s.a.s.d.impl.DatabaseMetadataServiceImpl - Unable to get schemas metadata
[...]
.ErrorPropagationThriftHandler:runSafely:ErrorPropagationThriftHandler.scala:119], errorCode:0, errorMessage:Configuration CONNECTION_TYPE is not available.).

[sudonitt018]

hi, were you able to resolve the error? I am also facing the exact same error.

DC connect: 3.15.0 JDBC Driver: 2.6.34 JAVA: OpenJDK 11

[mflpopescu]

@sudonitt018 you'll need to make the connection using the cluster JDBC endpoint (it won't work with the warehouse endpoint)

[sudonitt018]

@mflpopescu , thanks for the response, what is the format of that? Where can we find it?

[mflpopescu]

@sudonitt018 In the guide linked in the original post, see section "JDBC URL Settings"

[steyler-db]

Hello @mflpopescu why SQL warehouse doesn't work ? @sudonitt018 you'll need to make the connection using the cluster JDBC endpoint (it won't work with the warehouse endpoint) If I use the Splunk Add on it works, but the SQL warehouse needs to be always turned on, why this is needed, this will be a lot of cost, can this be more likely to splunk db connect to launch the cluster when it connects to databricks SQL warehouse?