README.md

---
title: Content Analysis Workflow Automation
emoji: 📊
colorFrom: blue
colorTo: green
sdk: streamlit
sdk_version: "1.36.0"
app_file: app.py
pinned: false
---

# Content Analysis Workflow Automation

This Streamlit dashboard integrates OpenAI and Snowflake to generate and run
SQL queries for content analysis. Provide a description of the content you want
to analyze and the app will:

1. Use OpenAI to craft a Snowflake SQL query based on custom instructions.
2. Execute the query against your Snowflake warehouse.
3. Display the results in an interactive table.

## Setup

1. Install dependencies:
   ```bash
   pip install -r requirements.txt
   ```
2. Set the required environment variables for OpenAI and Snowflake:
   - `OPENAI_API_KEY`
   - `SNOWFLAKE_USER`
   - `SNOWFLAKE_PASSWORD`
   - `SNOWFLAKE_ACCOUNT`
   - `SNOWFLAKE_WAREHOUSE`
   - `SNOWFLAKE_DATABASE`
   - `SNOWFLAKE_SCHEMA`
3. Run the app:
   ```bash
   streamlit run app.py
   ```