The current UDF implementation stores UDFs in a catalogue.schema location. This requires reference/call to said udf location; example `select my_catalogue.my_schema.my_udf()`. Or have the sql execute from that schema.
In Snowflake, UDFs are globally available. Say i define an Uber H3 UDF or a UUID5 UDF. Then I want to use this everywhere, without specifying some_catalogue.some_schema.uuid5. I just want to do `select uuid5(name)`.
Alternatively, if we can allow functions to be stored on the catalogue level.
In my opinion, the UDF functionality is very useless at a larger scale with the current implementation.