Spaces:

Raptive-NC
/

Content_Analysis_Workflow_Automation

Build error

App Files Files Community

Content_Analysis_Workflow_Automation / README.md

github-actions[bot]

sync: automatic content update from github

85b0d4d 6 months ago

preview code

raw

history blame contribute delete

957 Bytes

A newer version of the Streamlit SDK is available: 1.54.0

Upgrade

metadata

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:

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
```