SnowPro Associate: Platform Question 263
Single answer● Use Snowsight to identify particular tablesA data engineer is asked to quickly find a table in Snowsight that stores daily sales data, but they do not remember which schema contains it. They know the table name includes the word "SALES" and want to identify the table without writing SQL. Which action in Snowsight is the best way to locate the table?
- A
Use Snowsight's object search or browse the Data area, then filter/search for tables whose names include "SALES" across accessible databases and schemas.
- B
Open Worksheets and run SHOW TABLES IN ACCOUNT because Snowsight cannot identify tables unless SQL is used.
- C
Use the Activity page in Snowsight to locate tables by reviewing warehouse query history until the correct schema appears.
- D
Open the Admin area in Snowsight and inspect users and roles to determine which table contains sales data.
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use Snowsight's Data interface and search/filter capabilities to identify the table by name pattern. Snowsight is designed to let users explore accessible databases, schemas, and tables without requiring SQL for basic object discovery. In real-world workflows, this is the fastest approach when a user knows only part of a table name and needs to find it visually. SQL commands such as SHOW TABLES can also identify tables, but they are not the best fit here because the requirement is specifically to use Snowsight without writing SQL. This matches Snowflake best practices for using Snowsight as a graphical interface for browsing and identifying database objects.
- A. Correct.
Correct. In Snowsight, a user can use the Data area and built-in search/filter capabilities to browse databases, schemas, and tables they have access to. This is the most direct no-code method for identifying a table when only part of the name is known. It aligns with the practical use of Snowsight for object discovery.
- B. Incorrect.
Incorrect. Running SHOW TABLES is a valid SQL-based approach, but the scenario explicitly asks for a method without writing SQL. Also, the statement that Snowsight cannot identify tables unless SQL is used is false because Snowsight includes graphical navigation and search for data objects.
- C. Incorrect.
Incorrect. The Activity page is intended for monitoring activity such as queries and usage patterns, not for directly discovering table objects by name. Someone might choose this if they confuse operational monitoring with object discovery.
- D. Incorrect.
Incorrect. The Admin area is used for account administration and governance-related tasks, not for locating a specific table by partial name. This reflects a misunderstanding of Snowsight navigation and the purpose of administrative views.