Forum Discussion

SMATIN's avatar
SMATIN
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

Multi-statement table valued functions support in Fabric Data Warehouse and SQL analytics endpoint

Currently, I am not able to create my multi-statement TVF in Fabric Warehouse and SQL anlalytics endpoint. I would like to be able to do that w/o needing to do a code change.
data warehouse
Warehouse
V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi SMATIN ,

At the moment, Microsoft Fabric Warehouse and SQL Analytics Endpoint don’t support multi-statement table-valued functions (TVFs). Only inline TVFs (single SELECT statement) are allowed.

If your logic needs multiple steps, you can

  1. Try converting it into a view or an inline TVF

  2. Or move the logic to a notebook or pipeline

Microsoft may add support in future updates, but for now, code changes are needed to work around this.
You can check the official documentation here:  CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn

 

Keep an Eye on Updates: Microsoft frequently updates its services and features. Check the Fabric Data Warehouse release plan for any announcements regarding MSTVF support.

 

Regards,
Yugandhar.