Shixuan Fan
Shixuan Fan
Hi Ken, thanks for the feedback. Today extracting common subqueries into CTE is not supported. This is challenging to get right and requires some designs/thoughts, but it is definitely a...
@krish-adi : Can you post this in https://github.com/snowflakedb/snowpark-python instead? I'm going to close this one.
Sorry I misread, but this really has nothing to do with either the connector or snowpark api. Let's just keep it here.
@krish-adi : sorry for the confusion, we could keep it here.
Using `*args` in general does not make sense because the definition of the UDF/SP contains the number of arguments as well. I'm a bit surprised that it would work with...
@sfc-gh-yixie : Yes. I just checked and it seems like in UDF the check considered varargs, but not SP. We should improve our validation, instead of removing it. I added...
And again, thanks for raising it to us!
Makes total sense to me. We should probably mimic the mysql behavior, but we also need to make sure we handle it correctly in snowflake's context.
These seem like something we should fix and don't seem very hard at the first glance. @sfc-gh-mkeller What do you think?
Thanks for the feedback. We plan to work on this early next year.