Forum Discussion
Solved
Azure Databricks - SQL query - Configuration not available
I spun up a FINO's Legend Studio instance locally, and I was able to establish a connectivity between the application and my Azure Databricks resource.
However, when I run a SQL query from Legend Studio, which is supposed to execute on Databricks, I get a "Configuration legend_databricks_http_path is not available" error from Databricks:
By going to the "Query History" on Azure Databricks, I can confirm Legend Studio is reaching Databricks, but this is responding with the error mentioned above. The "See error" button doesn't provide any additional error details.
Is anyone familiar with the "Configuration is not available" type of error in Azure Databricks SQL queries?
I figured this out. I was able to execute a query in Legend Studio against Azure Databricks by using the HTTP path of the cluster, not the SQL warehouse:
Try this and the reference link:
- Check Configuration Settings: Ensure that the legend_databricks_http_path configuration is correctly set in your Legend Studio instance. Double-check the settings to make sure there are no typos or missing values.
- Verify Connectivity: Since you mentioned that Legend Studio is reaching Databricks, it's good to confirm that there are no network issues or firewall restrictions blocking the connection.
Solved: Databricks apps, data plane configuration not supp... - Databricks Community - 99994
I figured this out. I was able to execute a query in Legend Studio against Azure Databricks by using the HTTP path of the cluster, not the SQL warehouse:
