Status:
Under Review
Allow calls of Fabric SQL Database stored procedures from Data Warehouse
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and events during ETL loads.
3 Comments
Hi, not really. I would need to make a lot of small calls, and I'm afraid that using Fabric UDFs would introduce another unnecessary engine, resulting in quite a bit of overhead for this kind of scenario. Am I wrong?
Anyway, a big thank you for bringing Fabric UDFs to the Warehouse! 🙂
- jovanpop-msft
Microsoft Employee
Look at the Microsoft Fabric DW Roadmap and you will see that in a month you will be able to call Fabric UDF from DW SQL code.
Once you call Fabric UDF you can use this UDF to call stored procedure in SQL DB.
Would this help in your scenario? - Status added:Under Review
