Unable to connect to external metastore from databricks warehouse cluster

Ravi_Bobbili — Fri, 10 May 2024 11:45:46 GMT

Hi,
We are using azure sql as external meta store. We are trying to access this external metastore from databricks warehouse clusters but getting error. `data` property must be defined in SQL query response . but we are able to connect to the same using standard Databricks cluster.

Below were configured for sql cluster

spark.hadoop.javax.jdo.option.ConnectionDriverName com.microsoft.sqlserver.jdbc.SQLServerDriver
spark.hadoop.javax.jdo.option.ConnectionURL <connectiondetails>
spark.hadoop.javax.jdo.option.ConnectionUserName <username>
spark.hadoop.javax.jdo.option.ConnectionPassword <password>
spark.sql.hive.metastore.jars builtin
spark.sql.hive.metastore.version 2.3.9

topic Unable to connect to external metastore from databricks warehouse cluster in Data Engineering

Unable to connect to external metastore from databricks warehouse cluster