chart-gpt

Installation

  1. Install Poetry

  2. Set up a new virtual environment and install the requirements:

python3 -m venv venv
source venv/bin/activate
  1. Install the requirements:
poetry install
  1. Create a Snowflake trial account. Free for 30 days and when you’re done you create a new one.

  2. 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).

  3. Set the necessary environment variables:
    OPENAI_API_KEY=sk-***
    SF_ACCOUNT=XYZ12345
    SF_DATABASE=SNOWFLAKE_SAMPLE_DATA
    SF_PASSWORD=$ecret
    SF_ROLE=ACCOUNTADMIN
    SF_SCHEMA=TPCH_SF1
    
  4. Run the app:
    streamlit run ChartGPT.py