Can we execute a Stored procedure(Azure SQL DB) through Databricks Notebook??

Anusha Rudra 6 Reputation points
2022-04-20T08:16:44.697+00:00

I already have a stored Procedure which has Merge Statement logic, I would like to execute this SP through Databricks notebook. Is there a way to do this?

Azure SQL Database
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,045 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee
    2022-04-21T06:00:29.717+00:00

    Hello @Anusha Rudra ,

    Thanks for the question and using MS Q&A platform.

    You may checkout the below articles which explains how to call a stored procedure through Databricks Notebooks:

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators