# HealthFlow Analytics — Python dependencies
# Install with:  pip install -r requirements.txt
#
# Tip: use a virtual environment so these don't clash with other projects:
#   python -m venv .venv
#   source .venv/bin/activate        (Windows: .venv\Scripts\activate)
#   pip install -r requirements.txt

# --- Core: talk to Snowflake from Python ---------------------------------
# The [pandas] extra adds write_pandas / fetch_pandas helpers (handy, optional).
snowflake-connector-python[pandas]>=3.7.0

# --- Phase 03: read the two "Google Sheets" datasets ---------------------
# Only needed if you run gsheet_loader.py with  --source gsheets.
# The default  --source local  mode does NOT need these.
gspread>=6.0.0
google-auth>=2.28.0

# --- Convenience: load Snowflake credentials from a .env file ------------
# Optional. The code works without it (reads plain environment variables),
# but a .env file is the easiest way for a beginner to store credentials.
python-dotenv>=1.0.0
