snowChat is an intuitive and user-friendly application that allows users to interact with their Snowflake data using natural language queries. Type in your questions or requests, and SnowChat will generate the appropriate SQL query and return the data you need. No more complex SQL queries or digging through tables - SnowChat makes it easy to access your data! By bringing data one step closer, SnowChat empowers users to make data-driven decisions faster and more efficiently, reducing the barriers between users and the insights they seek.
https://github.com/kaarthik108/snowChat/assets/53030784/24105e23-69d3-4676-b6d6-d8157dd1580a
Clone this repository: git clone https://github.com/yourusername/snowchat.git
Install the required packages: cd snowchat pip install -r requirements.txt
Set up your OPENAI_API_KEY
, ACCOUNT
, USER_NAME
, PASSWORD
, ROLE
, DATABASE
, SCHEMA
, WAREHOUSE
, SUPABASE_URL
, SUPABASE_SERVICE_KEY
and REPLICATE_API_TOKEN
in project directory secrets.toml
.
Make you're schemas and store them in docs folder that matches you're database.
Create supabase extention, table and function from the supabase/scripts.sql.
Run python ingest.py
to get convert to embeddings and store as an index file.
Run the Streamlit app to start chatting: streamlit run main.py
[]
Feel free to contribute to this project by submitting a pull request or opening an issue. Your feedback and suggestions are greatly appreciated!
This project is licensed under the MIT License - see the LICENSE file for details.