In the past I have only used Azure Data Factory to run a Databricks Notebook via pipeline activity in a stored procedure.

Can someone let me know if its actually possible to run an Azure Databricks Notebook purely from a stored procedure in Azure SQL Server?

CodePudding user response：

Theoretically it's possible to call the Databricks Jobs REST API from TSQL in on-prem installations (like this), but according to the answer on MS site this is not supported for Azure SQL.

But the first question that should be asked - why do you need this?