Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
How does Azure Data factory use Stored Procedure or Used Defined Function built in Snowflake?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 46%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWG%3C/text%3E%3C/svg%3E)
Wu Guobi
0
Reputation points
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.
{count} votes
-
Nandan Hegde 31,511 Reputation points MVP2023-07-27T08:51:50.79+00:00 Can you please confirm the below:
- is the SP execution successful when you execute it directly in snowflake?
- Can you share the screenshot of your lookup activity
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee2023-08-01T00:25:51.4466667+00:00 @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?
Thanks
Sign in to comment