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.

 

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi SMATIN ,
Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.

Thank You.