Unable to connect to external metastore from databricks warehouse cluster

[Ravi_Bobbili]

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

[Kaniz_Fatma]

Hi @Ravi_Bobbili, I understand that you’re having trouble accessing an Azure SQL external metastore from Databricks warehouse clusters.

This issue might be due to a few reasons:

1. Ensure that your configuration settings are correct. The error message “data property must be defined in SQL query response” suggests that there might be...¹.

2. There have been instances where the SQL endpoint is unable to connect to the external hive metastore¹. The issue might be due to the DBFS support for SQL not being available¹. You might need to get the jar from Maven¹.

3. If IP allow listing is enabled for your workspace, it will not allow arbitrary connections from Spar...². The subnet(s) for the data plane needs to be added to the IP allow list².

Please check these points and let me know if the issue persists. I’m here to help! 😊