Install Poetry
Set up a new virtual environment and install the requirements:
python3 -m venv venv
source venv/bin/activate
poetry install
Create a Snowflake trial account. Free for 30 days and when you’re done you create a new one.
Create an OpenAI account and get an API key. This app costs very little even with heavy usage (my highest bill was $20 for a whole month).
OPENAI_API_KEY=sk-***
SF_ACCOUNT=XYZ12345
SF_DATABASE=SNOWFLAKE_SAMPLE_DATA
SF_PASSWORD=$ecret
SF_ROLE=ACCOUNTADMIN
SF_SCHEMA=TPCH_SF1
streamlit run ChartGPT.py