What is the best practice wrt procedures? #109
Replies: 2 comments 1 reply
-
@AndreiTapai , manual drops should not be necessary. Could you share procedure YAML config (without body) and name of YAML file? I'll try to reproduce it. Snowflake might have some hidden rules around overloading which are currently not taken into account. |
Beta Was this translation helpful? Give feedback.
-
@AndreiTapai , ok I see what happens here. Normally procedures with different sets of arguments are handled independently. But introduction of "default" values made things awkward for Snowflake, since So Snowflake introduced an artificial rule that polymorphism is not supported for procedures with default values. And this rule blocks creation of other procedures with potentially conflicting signatures. Not sure if it is worth a special fix, since:
As a more general fix, we may consider dropping objects first before creating new ones. In theory, it should be a safe change with no side effects. I'll consider it for future updates, especially if other object types can benefit too. |
Beta Was this translation helpful? Give feedback.
-
Hi @littleK0i ,
I have some procedures that are constantly being iterated on. When applying changes to the Snowflake database more often than not we have errors like "Cannot overload procedure test as it would cause ambiguous PROCEDURE overloading." Is it absolutely necessary to run a drop script for these before running snowddl?
Beta Was this translation helpful? Give feedback.
All reactions