Spaces:

Avisut
/

Content_Analysis_Workflow_Automation

Configuration error

App Files Files Community

Content_Analysis_Workflow_Automation / README.md

github-actions[bot]

sync: automatic content update from github

1d4a839 6 months ago

preview code

raw

history blame contribute delete

793 Bytes

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:

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

Setup

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