Answered

Snowflake custom function / procedure name overloading

8 months ago • updated by 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

Vote

Replies 2
Oldest first
- Newest first
- Oldest first

Under review

8 months ago

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

6 months ago

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

Customer support service by UserEcho