Unity Catalog Functions

Let's list the functions.

bin/uc function list --catalog unity --schema default

You should see a few functions. Let's get the metadata of one of these functions.

bin/uc function get --full_name unity.default.sum

In the printed metadata, pay attention to the columns input_parameters, external_language, and routine_definition.

This seems like a simple python function that takes 3 arguments and returns the sum of them. Let's try calling this function.

Behind the scenes, the invocation of the function is achieved by calling the python script at etc/data/function/python_engine.py with the function name and arguments.

bin/uc function call --full_name unity.default.sum --input_params "1,2,3"

Voila! You have called a function stored in UC. Let's try and create a new function.

bin/uc function create --full_name unity.default.myFunction --data_type INT --input_params "a int, b int" --def "c=a*b\nreturn c"

You can test out the newly created function by invoking it.

bin/uc function call --full_name unity.default.myFunction --input_params "2,3"

You should see the result is 6.