View the Dependencies of a Stored Procedure
In summary, sys.sqlexpressiondependencies doesn’t return the referenced objects of stored procedure. This works for SQL Server and in the online documentation it is likely mentioned as supported scenario. Unfortunately, it is not supported at the moment. Please add this functionality.
Kalyan Chanumolu commented
sys.sql_expression_dependencies only includes the dependency information for Views.
Other entity types such as Procedures, triggers, CLR, UDF, filtered statistics, etc. are not supported in Azure DW
Hey we need this in order to find all the dependencies on a proc like the tables inside so that we can plan our Data factory components execution/pipelines and we can also avoid waits in the ADW.