In this guide, we will review how to build a Streamlit App within Snowflake that allows you to easily demo Cybersyn's Financial Data Package data tables with charts built in Vega-Lite.
Streamlit is a pure Python open source application framework that enables developers to quickly and easily write, share, and deploy data applications. Learn more about Streamlit.
Vega-Lite is an open-source high-level grammar of interactive graphics. It provides a concise, declarative JSON syntax to create an expressive range of visualizations for data analysis and presentation.
An application on Streamlit within Snowflake that connects directly to a data listing acquired (for free) through the Snowflake Marketplace. This application allows users to quickly demonstrate usage examples from data in the Cybersyn Financial Data Package. This data specifically focuses on the US banking system and respective financials and performance.
A Snowflake account
After logging into your Snowflake account, access Cybersyn's Financial Data Package in the Marketplace.
FINANCIAL_DATA_PACKAGEdatabase under Data on the left hand side panel.
FINANCIAL_STREAMLIT) for the Streamlit to live in.
FINANCIAL_STREAMLIT) with a name of your choosing (eg.
FINANCIAL_DATA_PACKAGElisting in your databases.
To see the Streamlit in the full window, click < Streamlit Apps on the top left and reopen the application you created (eg. Financial Streamlit).
All charts are setup to show a chart summary of the data, the raw data, and the SQL query to recreate the analysis.