Streamlit demo: 🌀 The Snowflake Usage Insights app

This app provides insights on a demo Snowflake account usage.

It was made using 🎈 Streamlit and the ❄️ Snowflake Python connector!

Can I use this app with my own Snowflake account?

This demo app currently only supports basic username / password authentication to connect to your Snowflake account. For security purposes, we recommend cloning this app and running it locally instead of on Streamlit Cloud. If you're interested, head over to the next section!

Run this app locally

Follow these steps:

1. Set up dependencies. Get Pipenv, clone/fork this repository and within the directory, run:

pipenv clean && pipenv install --python 3.9

2. Set up credentials. Create a file .streamlit/secrets.toml and fill in your Snowflake account credentials. The file should look like this:

[sf_usage_app]
user = "..."
account = "..."
password = "..."
warehouse = "..."

3. Run the app locally. Simply run:

pipenv run streamlit run Home.py

🎊 Your browser should now be opened with the Streamlit app running locally!

Contribute

Feel free to contribute! Simply make sure to:

1. Install development dependencies pipenv install --python 3.9 --dev
2. Set up pre-commit hooks pipenv run pre-commit install

Questions? Comments?

Please ask in the Streamlit community.