SnowPro Associate: Platform Question 20
Single answer1.2 Outline the key Snowflake user interfaces.A data engineering team is onboarding several business analysts to Snowflake. The analysts need a browser-based interface where they can run ad hoc SQL queries, browse database objects, review query history, and use built-in worksheets without installing desktop software. At the same time, the engineering lead wants to avoid recommending command-line tools or programmatic connectors for these users. Which Snowflake user interface best fits this requirement?
- A
Snowsight
- B
SnowSQL
- C
Python Connector
- D
JDBC Driver
Show answer and explanation
Correct answer: A
Explanation
The best answer is Snowsight because it is Snowflake's primary browser-based user interface for interactive analysis and administration. In real-world onboarding scenarios, Snowsight is commonly recommended for analysts and other interactive users because it provides worksheets, query history, object browsing, and other visual features without requiring local installation. By contrast, SnowSQL is a CLI tool, and connectors/drivers such as Python Connector and JDBC are integration interfaces used by applications or scripts rather than end-user graphical interfaces. This aligns with Snowflake documentation describing Snowsight as the web experience and SnowSQL/connectors as separate access methods for command-line and programmatic interaction.
- A. Correct.
Correct. Snowsight is Snowflake's web-based user interface designed for interactive use in a browser. It supports worksheets for running SQL, object exploration, query history, dashboards and monitoring features, making it the best fit for business analysts who need a graphical interface without installing local tools.
- B. Incorrect.
Incorrect. SnowSQL is a command-line client, not a browser-based graphical interface. While it can run SQL and perform administrative tasks, it does not meet the requirement for analysts who want an easy-to-use web UI with visual navigation.
- C. Incorrect.
Incorrect. The Python Connector is a programmatic interface for building applications or scripts that connect to Snowflake. It is intended for developers and automation use cases, not for analysts seeking an interactive browser-based experience.
- D. Incorrect.
Incorrect. The JDBC Driver enables Java applications and BI tools to connect to Snowflake programmatically. It is not itself a user-facing web interface for browsing objects and running ad hoc queries directly.