How does Azure Data factory use Stored Procedure or Used Defined Function built in Snowflake?
Hi Microsoft team,
How does Azure Data Factory use Stored Procedure or Used Defined Function built in Snowflake?
It seems stored procedure activity does not support connection to Snowflake. So I tried lookup and script activity. But an error appeared, which said it was an unknown table function.
Why is that case? How could I fix that?
Thanks in advance.
@Wu Guobi Thanks for using Microsoft Q&A forum and posting your query.
As per the public documentation, Snowflake is supported by Lookup and Script activity. As @Nandan Hegde requested, could you please confirm if the SP was executable in snowflake? If yes, then could you please share the error message that you are seeing while executing from ADF Script or lookup activity?
Sign in to comment