jsmith6's avatar
jsmith6
New Member
2 years ago
Status:
Completed

Scalar Function Support

We are migrating a data warehouse and there is currently no support for SQL Scalar Functions (TVF only supported) in Fabric Warehouse.
data warehouse
SMATIN's avatar
SMATIN
Microsoft Employee
7 months ago
Status changed:
New
to
Completed

Sql native scalar user-defined functions are are publicly available (preview). See

- CREATE FUNCTION (Microsoft Fabric, Azure Synapse Analytics) - SQL Server | Microsoft Learn

- https://blog.fabric.microsoft.com/blog/inline-scalar-user-defined-functions-udfs-in-microsoft-fabric-warehouse-preview?ft=All

- How to make your SQL scalar user-defined function (UDF) inlineable in Microsoft Fabric Warehouse  | Microsoft Fabric Blog | Microsoft Fabric

 

Inlineability plays critial part in understanding requirements. 
Feel free to reply and leave feedback on existing scope.

Recent ideas