Forum Discussion
Fabric Data Warehouse - Creating Functions
Hey all
Need some information about the below questions:
I'm trying to create a function in Fabric Data Warehouse
- Is it currently possible to create user-defined functions within Fabric Data Warehouse?
- If functions are supported, what's the correct syntax for creating them?
- Are there any limitations on the supported return types for functions?
Any insights or pointers would be greatly appreciated.
@(v-nikhilan-msft)
Hi jashfabric
Thanks for using Fabric Community.
1) You can create UDF in warehouse.
But scalar functions are not yet available in Fabric. For more information please refer to this link: Link1
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.
CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn
Hope this helps. Please let us know if you have any further questions.
1 Reply
Hi jashfabric
Thanks for using Fabric Community.
1) You can create UDF in warehouse.
But scalar functions are not yet available in Fabric. For more information please refer to this link: Link1
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.
CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn
Hope this helps. Please let us know if you have any further questions.