What Is User Defined Function (UDF)?

A User Defined Function (UDF) is a custom programming function that allows users to reuse processes without having to rewrite code. For example, a complex calculation can be programmed using SQL and stored as a UDF. When this calculation needs to be used in the future on a different set of data, rather than rewriting the function, the user can simply call the UDF. This allows programmers to work more efficiently by creating and referencing custom procedures rather than rewriting them each time they need to be used. UDFs also allow code to be executed faster by caching and reusing procedures rather than recompiling them on each use.

More Data Engineering Terms
Data Ingestion
Terme Suivant
Regex (Regular Expression)
Related Resources
 
Témoignage client
Saving Over 75 Hours Day with Automated Forecasting
Financial services company, Brookson gave their customers better digital experiences by elevating and scaling their internal team.
  • Préparation et analytique des données
  • Data Science et Machine Learning
  • Automatisation des processus
Lire maintenant
 
Témoignage client
Nippon Caterpillar Japan rationalise ses opérations d’analyse
Découvrez comment la filiale Nippon Caterpillar au Japon a transformé ses données pour booster l'efficacité opérationnelle.
  • Préparation et analytique des données
  • Marketing
  • Asia Pacific
Lire maintenant