This repository contains a Text-to-SQL model application that ussing Google Gemini Pro and Streamlit.

It fetches data from a Snowflake database. The application allows users to input natural language queries, which are then converted into SQL queries and executed against a Snowflake database. The results are displayed in a user-friendly interface powered by Streamlit.

• Natural Language to SQL Conversion: Converts user input from plain English to SQL queries.

• Google API Integration: Utilizes Google APIs for enhanced processing capabilities.

• Snowflake Data Fetching: Connects to a Snowflake data warehouse to execute SQL queries and fetch results.

• Streamlit Interface: Provides an intuitive and interactive user interface for input and result display.

Clone the project

  git clone https://github.com/AayushhGoyal/text_tosql.git

Go to the project directory

  cd text_tosql

Install dependencies

  pip install -r requirements.txt

Start the server

  streamlit run app.py

To run this project, you will need to add the following environment variables to your .env file

API_KEY

SNOWFLAKE_USER=AYUSHG28 SNOWFLAKE_PASSWORD=Ayush@2003 SNOWFLAKE_WAREHOUSE=COMPUTE_WH SNOWFLAKE_ROLE=ACCOUNTADMIN SNOWFLAKE_DATABASE=FINANCIAL__ECONOMIC_ESSENTIALS SNOWFLAKE_ACCOUNT=bxotize-ht12968 GOOGLE_API_KEY="AIzaSyDey7S32FUaJ-4OYuV7RJzLD7lbKwVf8iA"

Here's a demo video

https://drive.google.com/file/d/18a7MMk8B0s_T6yMrWqmnPsxWTpJUeKu2/view?usp=sharing

In this table you can access

• C_CUSTKEY
• C_NAME
• C_ADDRESS
• C_NATIONKEY
• C_PHONE
• C_ACCTBAL
• C_MKTSEGMENT
• C_COMMENT
• L_ORDERKEY
• L_PARTKEY
• L_SUPPKEY
• L_LINENUMBER
• L_QUANTITY
• L_EXTENDEDPRICE
• L_DISCOUNT
• L_TAX
• L_RETURNFLAG
• L_LINESTATUS
• L_SHIPDATE
• L_COMMITDATE
• L_RECEIPTDATE
• L_SHIPINSTRUCT
• L_SHIPMODE
• L_COMMENT
• N_NATIONKEY
• N_NAME
• N_REGIONKEY
• N_COMMENT
• O_ORDERKEY
• O_CUSTKEY
• O_ORDERSTATUS
• O_TOTALPRICE
• O_ORDERDATE
• O_ORDERPRIORITY
• O_CLERK
• O_SHIPPRIORITY
• O_COMMENT
• P_PARTKEY
• P_NAME
• P_MFGR
• P_BRAND
• P_TYPE
• P_SIZE
• P_CONTAINER
• P_RETAILPRICE
• P_COMMENT
• PS_PARTKEY
• PS_SUPPKEY
• PS_AVAILQTY
• PS_SUPPLYCOST
• PS_COMMENT
• R_REGIONKEY
• R_NAME
• R_COMMENT
• S_SUPPKEY
• S_NAME
• S_ADDRESS
• S_NATIONKEY
• S_PHONE
• S_ACCTBAL
• S_COMMENT]