We are migrating a data warehouse and there is currently no support for SQL Scalar Functions (TVF only supported) in Fabric Warehouse.
8 Comments
Yeah, same here, this is a pain as we're having to convert the function code so we can use it in other places like views and procs, but some require a lot of refactoring... please add it :)
Migration of our DW-solution from Synapse to Fabric will be enormously more complex if scalar functions are not supported.
Honestly we don´t understand why this rather basic feature is no longer available and hope that it will be implemented soon.
Ditto we use these extensively as most of our code is meta data driven and scalar functions is the code that generates the code for procedures based on install / client base. To migrate our warehouse build to not use them involves mass rewrite of our code.
SMATINMicrosoft Employee
Thank you for your feedback. We are working on adding support for SQL scalar UDFs in Fabric Warehouse. Stay tuned for further updates.
- Status added:New
anon97242Advocate IV
+1- SMATINStatus changed:NewtoCompleted
Sql native scalar user-defined functions are are publicly available (preview). See
- CREATE FUNCTION (Microsoft Fabric, Azure Synapse Analytics) - SQL Server | Microsoft Learn
Inlineability plays critial part in understanding requirements.
Feel free to reply and leave feedback on existing scope.
