Forum Discussion

smpa01's avatar
smpa01
Community Champion
1 year ago

RE: udf

Can you please confirm whether udfs are all session scoped and persistent udfs are not possible to create (in lakehouse) as one can in databricks catalog?
Data Engineering
Lakehouse
Notebook
v-prasare's avatar
v-prasare
Community Support
1 year ago

Hi smpa01,

We are here to check whether solution provided answers your question. If you still have any additional questions please do let us know

 

 

Thanks,

Prashanth Are

MS Fabric community support

  • smpa01's avatar
    smpa01
    Community Champion
    1 year ago

    What is the practical use case of udf in fabric then?

    • AndreyBear's avatar
      AndreyBear
      Advocate II
      8 months ago

      Can you clarify your question? I'm suspecting a terminology confusion here.
      Fabric UDFs execute their code in a per-session scope, which is a good thing. Having only a single persistant instance of a UDF would be a fun way to leak session states from one call to the other.  They are essentially rest-lke. You can make a UDF that acts something onto a backend/callback (aka POST) - e.g. writes data, or triggers a pipeline, etc.