From Snowflake to Excel via Streamlit

Disclaimer: The views expressed in this article are mine alone and do not necessarily reflect the view of my current, former, or future employers.

I love Snowflake and I love Streamlit. I love Snowflake because it makes easy to manage my data and I love Streamlit because it makes simple to build beautiful data intensive web applications.

Some users like Excel and this is why I wrote this article that explains how to create a simple Streamlit application where users can download Snowflake data in Excel format.

The article assumes that you have access to a Snowflake account and Python installed in your machine.

What we are going to build

We are going to build a very simple application that display the result of a query as table and shows one button that allows to download the data as an Excel file. The query gets data from the table “CUSTOMER” in the schema SNOWFLAKE_SAMPLE_DATA. The GUI will look like this

Step 1: project setup

First you need to create a virtual environment using Python 3.9.13 (you can use pyenv, for example) and activate it.

Second you need to read the requirements to install the Snowflake python-pandas connector…