In Snowflake, unqualified object names (e.g., just my_table instead of schema.my_table) inside a User-Defined Function (UDF) are resolved using the SEARCH_PATH. This parameter defines the order of schemas that Snowflake searches when trying to resolve object names that are not fully qualified.
This behavior applies both during creation and execution of the UDF.
The correct answer is B.
In queries, unqualified object names are resolved through a search path.
The SEARCH_PATH is not used inside views or Writing User-Defined Functions (UDFs). All unqualified objects in a view or UDF definition will be resolved in the view’s or UDF’s schema only.
https://docs.snowflake.com/en/sql-reference/name-resolution#name-resolution-in-queries
In queries, unqualified object names are resolved through a search path.
The SEARCH_PATH is not used inside views or Writing User-Defined Functions (UDFs). All unqualifed objects in a view or UDF definition will be resolved in the view’s or UDF’s schema only.
https://docs.snowflake.com/en/sql-reference/name-resolution
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MITZ619
1 month, 1 week ago_yyukta
9 months, 2 weeks agoBobFar
1 year, 2 months agoMultiCloudIronMan
1 year, 5 months agoshujaz
1 year, 6 months agovishnuas
1 year agodmitriypo
1 year, 7 months agoOTE
1 year, 9 months agoSimbajagnole
1 year, 10 months ago