A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names.
How will those object names be resolved during execution?
A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names.
How will those object names be resolved during execution?
When writing a User-Defined Function (UDF) in Snowflake, unqualified object names are resolved during execution by looking only within the schema that the UDF belongs to. This approach ensures that the function operates in a consistent and predictable manner, without being affected by changes to the search path or other schemas.
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
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
Should be B https://docs.snowflake.com/en/sql-reference/name-resolution
B. Snowflake will only check the schema the UDF belongs to
correct
Selected Answer A if search_path than it has to be A
Not for UDF or views. so answer is B
https://docs.snowflake.com/en/sql-reference/name-resolution#:~:text=The%20SEARCH_PATH%20is%20not%20used%20inside%20views%20or%20User%2DDefined%20Functions%20Overview.%20All%20unqualifed%20objects%20in%20a%20view%20or%20UDF%20definition%20will%20be%20resolved%20in%20the%20view%E2%80%99s%20or%20UDF%E2%80%99s%20schema%20only.