SnowPro Associate: Platform Question 53
Single answerObject browsersA data engineer is troubleshooting why a newly created table is not visible in Snowsight for an analyst. The engineer can confirm the table exists and that the analyst has been granted SELECT on the table. The analyst is using Snowsight's object browser to locate the table under the expected database and schema, but it does not appear. Which additional requirement must be met for the table to be visible in the object browser?
- A
The analyst's role must have USAGE on the warehouse currently selected in Snowsight.
- B
The analyst's role must have USAGE on the database and schema that contain the table.
- C
The table must be created as a temporary table so it is indexed by the object browser.
- D
The analyst must switch from Snowsight to Classic Console because Snowsight does not display recently created objects.
Show answer and explanation
Correct answer: B
Explanation
Snowflake object browsers, including Snowsight's navigation pane, reflect the privileges of the currently active role. To see a table in the hierarchy, the role generally needs USAGE on the database and schema and the appropriate privilege on the table itself, such as SELECT. A common misconception is that granting SELECT alone is enough; however, without container-level USAGE privileges, the object may exist but remain inaccessible or invisible in the browser. This aligns with Snowflake's access control model and documented best practice of granting privileges on parent objects as well as child objects when users need to browse and query data.
- A. Incorrect.
Incorrect. Warehouse access is required to run queries or use compute, but object visibility in the database/schema hierarchy depends on privileges on the container objects. Without USAGE on the database and schema, the analyst cannot navigate to the table in the object browser even if a warehouse is available.
- B. Correct.
Correct. In Snowflake, visibility of objects in interfaces such as Snowsight's object browser depends not only on privileges on the object itself but also on access to its parent containers. A role typically needs USAGE on the database and schema, in addition to the relevant object privilege such as SELECT on a table, to see and access the table through the browser.
- C. Incorrect.
Incorrect. Temporary tables are session-scoped and are not a requirement for object browser visibility. In fact, making the table temporary would reduce its visibility and persistence, not improve discoverability for another user.
- D. Incorrect.
Incorrect. Snowsight does display newly created objects when the active role has the necessary privileges. The issue described is about access control, not a limitation of Snowsight versus Classic Console.