Forum Discussion

jashfabric's avatar
jashfabric
Helper II
2 years ago
Solved

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 ...
Data Warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.