Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MaxBronder
Frequent Visitor

Best practice to substitute udf scalar value functions

In our current onprem data warehouse we have many scalar value functions with complex physics calculations.

Because scalar value functions are not supported I'm wondering what is the best practice now to substitute them.

Converting them to a multi statement tvf could be a solution, but they are also not supported.

Is this limitation only for preview or will there still be no support for Scalar and Mulit tvfs by the date of GA?

And if so, what would you recommend on how the replicate this functionality?

KR

1 ACCEPTED SOLUTION
v-nikhilan-msft
Community Support
Community Support

Hi @MaxBronder  ,
Thanks for using Fabric Community.

A quick suggestion is to use Python to implement those Physics calculations. A notebook can be used to

  • Read the source table(s) ( from Lakehouse  or Warehouse).
  • Compute the functions as needed.
  • Save the results in a lakehouse, together with a row identifier.
  • After that, SQL queries can join the original data with the newly created Lakehouse table and collect the results.

     

The support for scalar UDF or TVF is not in Fabric warehouse general availability scope. Scalar UDF is on our radar for post-general availability planning. We don't have a specific ETA to share at this moment.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Please let me know if you have any further queries.

View solution in original post

3 REPLIES 3
v-nikhilan-msft
Community Support
Community Support

Hi @MaxBronder  ,
Thanks for using Fabric Community.

A quick suggestion is to use Python to implement those Physics calculations. A notebook can be used to

  • Read the source table(s) ( from Lakehouse  or Warehouse).
  • Compute the functions as needed.
  • Save the results in a lakehouse, together with a row identifier.
  • After that, SQL queries can join the original data with the newly created Lakehouse table and collect the results.

     

The support for scalar UDF or TVF is not in Fabric warehouse general availability scope. Scalar UDF is on our radar for post-general availability planning. We don't have a specific ETA to share at this moment.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Please let me know if you have any further queries.

Hi @MaxBronder ,
We haven’t heard from you on the last response and was just checking back to see if your query has been resolved. Please let us know if you have any further queries.

Hi @MaxBronder ,

Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

MayFabricCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors