Avisut/Content_Analysis_Workflow_Automation

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. 1.Use OpenAI to craft a Snowflake SQL query based on custom instructions.
2. 2.Execute the query against your Snowflake warehouse.
3. 3.Display the results in an interactive table.

Setup

1. 1.Install dependencies:

   pip install -r requirements.txt

1. 1.Set the required environment variables for OpenAI and Snowflake:
2. 2.OPENAI_API_KEY
3. 3.SNOWFLAKE_USER
4. 4.SNOWFLAKE_PASSWORD
5. 5.SNOWFLAKE_ACCOUNT
6. 6.SNOWFLAKE_WAREHOUSE
7. 7.SNOWFLAKE_DATABASE
8. 8.SNOWFLAKE_SCHEMA
9. 9.Run the app:

   streamlit run app.py