+5
Answered

Snowflake custom function / procedure name overloading

roman gyger 8 months ago updated by Retinder Labana 6 months ago 2

Hi,

Snowflake supports for custom function/procedure name overloading. So data type of the arguments are part of the object identification. Currently this doesn't seems to be supported as I get following behavior:


- Warning, if 2 function/procedure exists with the same name, but having different data type arguments

- Pushing a generated source ddl files of a revision with more than 1 function/procedure with same name, but different arguments, to azure, will not raise any error, but no branch/pullrequest will be generated within azure.

May I have missed something or are this behaviors the result of a currently unsupported feature?

Thanks a lot for your support.

Best regsards,

Roman

Refs: 

https://docs.snowflake.com/en/developer-guide/udf-stored-procedure-naming-conventions

Under review

Hi Roman, 

Thank you for your question. Both of the items you've listed above are bugs in our system, both of which we do not handle correctly. I've alerted the team and we will add this to our log. Thank you as always for bringing this to our attention.

Answered

Hi Roman, 

I have tested this and would like to inform you that we have fixed this bug. If you have 2 functions with the same names but with different arguments then it will not throw an error anymore. 

Please let us know if you continue to see the issue.

Thanks, 
Retinder Labana