SnowPro Associate: Platform Question 87
Single answer● Visualize data using StreamlitA data analyst needs to build an internal dashboard in Snowflake to let business users explore daily sales by region without moving data to another platform. The analyst wants a solution that can query Snowflake tables directly and provide interactive charts and filters with minimal infrastructure management. Which approach best meets this requirement?
- A
Create a Streamlit in Snowflake app that queries the sales tables and renders interactive visualizations directly inside Snowflake.
- B
Export the sales data daily to CSV files in an internal stage and ask users to open the files in Snowsight for charting.
- C
Create a standard SQL view and assume Snowflake automatically converts it into an interactive dashboard for business users.
- D
Build a Python script on a local laptop that connects once to Snowflake, generates static image files, and emails them to users each morning.
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use Streamlit in Snowflake for interactive data visualization directly on Snowflake data. This is a practical fit when teams want to build internal apps with Python-based UI components, filters, and charts while minimizing data movement and operational overhead. Streamlit in Snowflake is intended for exactly this use case: creating and running data apps natively in Snowflake. By contrast, exporting CSVs, relying only on views, or sending static reports does not satisfy the requirement for interactive, self-service exploration. Snowflake documentation describes Streamlit in Snowflake as a way to build and deploy data applications using Streamlit while accessing Snowflake data securely and directly.
- A. Correct.
Correct. Streamlit in Snowflake is designed for building data applications and interactive visualizations that run within Snowflake. It allows developers to use Python and Streamlit components to query Snowflake data directly and present filters, charts, and other UI elements to users without exporting data to an external platform. This matches the requirement for interactive exploration with minimal infrastructure management.
- B. Incorrect.
Incorrect. Exporting data to CSV files adds unnecessary manual or batch-processing steps and does not provide an interactive application experience. While staged files can be accessed in Snowflake, this approach does not meet the requirement for direct querying and interactive dashboards for business users.
- C. Incorrect.
Incorrect. A SQL view can simplify access to the underlying sales data, but Snowflake does not automatically transform a view into an interactive dashboard. A visualization layer such as Snowsight dashboards or a Streamlit app is still needed. This option reflects the misconception that database objects alone provide end-user application functionality.
- D. Incorrect.
Incorrect. A local Python script generating static images is not an interactive solution and depends on external infrastructure and manual maintenance. It also does not align with the requirement to keep the user experience inside Snowflake with minimal infrastructure management.