Fabric Data Warehouse - Creating Functions

[jashfabric]

Hey all
Need some information about the below questions:
I'm trying to create a function in Fabric Data Warehouse

1. Is it currently possible to create user-defined functions within Fabric Data Warehouse?
2. If functions are supported, what's the correct syntax for creating them?
3. Are there any limitations on the supported return types for functions?

Any insights or pointers would be greatly appreciated.

@(v-nikhilan-msft)

[Anonymous · Accepted solution]

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.