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
