How to scan stored procedure from Azure SQL database?

Kavitha 16 Reputation points
2022-04-12T08:36:04.95+00:00

I have enabled "Lineage extraction(preview) option to check the lineage data flow & it will supported only for stored procedure.
Unable to scan Stored procedure from azure sql DB. Since SP is not listed under the asset details.
Could you please check and tell me?

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
527 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 59,326 Reputation points Microsoft Employee
    2022-04-13T06:50:28.147+00:00

    Hello @Kavitha ,

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

    You may checkout the below troubleshooting steps and do let us know if you still need any help on missing lineage from any stored procedure runs.

    • If no lineage is captured after a successful Lineage extraction run, it's possible that no stored procedures have run at least once since the scan is set up.
    • Lineage is captured for stored procedure runs that happened after a successful scan is set up. Lineage from past Stored procedure runs isn't captured.
    • If your database is processing heavy workloads with lots of stored procedure runs, lineage extraction will filter only the most recent runs. Stored procedure runs early in the 6 hour window or the run instances that create heavy query load won't be extracted.

    For more details, refer to Search Azure SQL Database assets and view runtime lineage.

    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

  2. Alp Kaya 46 Reputation points Microsoft Employee
    2023-01-03T21:38:46.28+00:00

    I have the same challenge.
    Has this been resolved? any updates?
    Thanks
    @PRADEEPCHEEKATLA-MSFT

    0 comments No comments