Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A Snowflake user is creating a User-Defined Function (UDF) that contains unqualified object names.
How will Snowflake resolve these object names when the UDF is executed?
A
Snowflake will resolve them according to the SEARCH_PATH parameter.
B
Snowflake will only check the schema the UDF belongs to.
C
Snowflake will first check the current schema, and then the schema the previous query used.
D
Snowflake will first check the current schema, and then the PUBLIC schema of the current database.
