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.

What is Streamlit?

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.

What is Vega-Lite?

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.

What You'll Build?

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.

What You'll Learn?


A Snowflake account

Step 1: Accessing Data in Snowflake Marketplace

Cybersyn Financial Data Package

After logging into your Snowflake account, access Cybersyn's Financial Data Package in the Marketplace.


Step 2: Create a Database & Schema

Step 3: Create a Streamlit

Step 4: Copy the Python code from GitHub


Step 5: Create a Database & Schema

You've successfully built the Cybersyn Financial Streamlit in Snowflake!

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.

Chart 1: Deposits by Size of Bank


Chart 2: Share of Total Commercial Bank Deposits, Small Banks (Non-Top 25)


Chart 3: Deposit Flows by Size of Bank, WoW


Chart 4: Monthly Change in Bank Branches Since COVID-19


Chart 5: As of Dec ‘23: Banks w/ $10B Assets with Lowest FDIC Insured Deposits


Chart 6: Bank Failures by Quarter


Chart 7: Banking Industry Net Interest Income vs. Fed Funds Rate


Chart 8: Interest Expense / Interest Income Ratio vs Fed Funds Rate