Question 90
Consider this Snowflake situation: A SQL script fails with Object does not exist because it assumes the active role automatically selects the correct schema. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: Unqualified Snowflake object names are resolved using current session namespace context. It supports the response: Set the expected database/schema context or use fully qualified identifiers before accessing objects. Confirm it with this observable result: A sample query succeeds against the intended fully qualified object after the context is set. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
The offered statement is true for this other mechanism: Virtual warehouses provide compute; tables are owned as database/schema objects. It does not explain the facts described here, which follow from: Unqualified Snowflake object names are resolved using current session namespace context.
This principle describes a separate cause: Programmatic connectors provide supported application access without automating browser presentation controls. The reported condition is governed by: Unqualified Snowflake object names are resolved using current session namespace context. The two mechanisms should not be conflated.
Micro-partition metadata enables pruning when values are localized enough to skip irrelevant partitions. That explanation applies to a different technical failure. Here the controlling principle is: Unqualified Snowflake object names are resolved using current session namespace context.