Connecting to Snowflake with Streamlit

To connect to any database within Streamlit, we mostly need to think about how to connect to that service in Python and then add some Streamlit-specific functions (like caching!) to improve the user experience. Luckily, Snowflake has invested a lot of time in making it incredibly easy to connect to Snowflake from Python; all you need to do is specify your account info and the Snowflake Python connector does the rest.

In this chapter, we’ll create and work in a new folder called database_examples and add a streamlit_app.py file, along with a Streamlit secrets file to get started:

mkdir database_examples
cd database_examples
touch streamlit_app.py
mkdir .streamlit
touch .streamlit/secrets.toml

Within the secrets.toml file, we need to add our username, password, account, and warehouse. Our username and password are the ones we added when we signed up for our Snowflake account, the warehouse is the virtual computer that Snowflake...