Free Preparation Discussions
MENU
Snowflake DSA-C02 Exam - Topic 1 Question 10 Discussion
Topic #: 1
Which type of Python UDFs let you define Python functions that receive batches of input rows as Pandas DataFrames and return batches of results as Pandas arrays or Series?
Vectorized Python UDFs let you define Python functions that receive batches of input rows as Pandas DataFrames and return batches of results as Pandas arrays or Series. You call vectorized Py-thon UDFs the same way you call other Python UDFs.
Advantages of using vectorized Python UDFs compared to the default row-by-row processing pat-tern include:
The potential for better performance if your Python code operates efficiently on batches of rows.
Less transformation logic required if you are calling into libraries that operate on Pandas Data-Frames or Pandas arrays.
When you use vectorized Python UDFs:
You do not need to change how you write queries using Python UDFs. All batching is handled by the UDF framework rather than your own code.
As with non-vectorized UDFs, there is no guarantee of which instances of your handler code will see which batches of input.
Kimberlie
9 months agoHerminia
9 months agoThaddeus
9 months agoColby
10 months agoLoren
10 months agoQuentin
10 months agoTenesha
10 months agoLavonda
10 months agoDyan
11 months agoNada
11 months agoTawanna
11 months agoCelestine
11 months agoLinette
11 months agoSherita
11 months agoLevi
11 months agoTrinidad
11 months agoMargart
11 months agoCrista
11 months ago