https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-Creating-Functions/m-p/3926276#M960 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="704119" data-lia-user-login="jashfabric" class="lia-mention lia-mention-user">jashfabric</a>&nbsp;<BR />Thanks for using Fabric Community.<BR />1) You can create UDF in warehouse.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P><BR />But scalar functions are not yet available in Fabric. For more information please refer to this link:<SPAN>&nbsp;</SPAN><A href="https://learn.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=aps-pdw-2016-au7&amp;viewFallbackFrom=sql-server-ver16" target="_blank" rel="noopener nofollow noreferrer">Link1</A><BR /><BR />For Transact-SQL functions, all scalar data types supported in Azure Synapse Analytics are allowed. The rowversion / timestamp data type is not a supported type. The cursor and table nonscalar types are not allowed.<BR /><A href="https://learn.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=aps-pdw-2016-au7" target="_blank">CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn</A></P> <P><BR />Hope this helps. Please let us know if you have any further questions.</P> Fri, 17 May 2024 07:36:26 GMT Anonymous 2024-05-17T07:36:26Z https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-Creating-Functions/m-p/3924171#M951 <P>Hey all<BR />Need some information about the below questions:<BR />I'm trying to create a function in Fabric Data Warehouse<BR /><BR /></P><OL><LI><SPAN>Is it currently possible to create user-defined functions within Fabric Data Warehouse?</SPAN></LI><LI><SPAN>If functions are supported,</SPAN><SPAN> what's the correct syntax for creating them?</SPAN></LI><LI><SPAN>Are there any limitations on the supported return types for functions?</SPAN></LI></OL><P><SPAN>Any insights or pointers would be greatly appreciated.</SPAN></P><P>&nbsp;</P><P><SPAN>@(v-nikhilan-msft)</SPAN></P> Thu, 16 May 2024 12:29:55 GMT https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-Creating-Functions/m-p/3924171#M951 jashfabric 2024-05-16T12:29:55Z https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-Creating-Functions/m-p/3926276#M960 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="704119" data-lia-user-login="jashfabric" class="lia-mention lia-mention-user">jashfabric</a>&nbsp;<BR />Thanks for using Fabric Community.<BR />1) You can create UDF in warehouse.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P><BR />But scalar functions are not yet available in Fabric. For more information please refer to this link:<SPAN>&nbsp;</SPAN><A href="https://learn.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=aps-pdw-2016-au7&amp;viewFallbackFrom=sql-server-ver16" target="_blank" rel="noopener nofollow noreferrer">Link1</A><BR /><BR />For Transact-SQL functions, all scalar data types supported in Azure Synapse Analytics are allowed. The rowversion / timestamp data type is not a supported type. The cursor and table nonscalar types are not allowed.<BR /><A href="https://learn.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=aps-pdw-2016-au7" target="_blank">CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn</A></P> <P><BR />Hope this helps. Please let us know if you have any further questions.</P> Fri, 17 May 2024 07:36:26 GMT https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-Creating-Functions/m-p/3926276#M960 Anonymous 2024-05-17T07:36:26Z