-
Clone this repository to your local machine.
-
Install the required dependencies using the following command:
pip install -r requirements.txt
-
Fill in your project_id, location, datset_id, table names and list of pre selected questions template in app.py based on requirements
-
Run app.py to start the Streamlit application:
streamlit run app.py
-
Open the Streamlit application in your web browser using the provided URL.
- Input your question in the text box, either in English or any other natural language.
- Press "Send" to send the question to the application or select pre-selected question
- The application will process the question using Palm2 and LangChain, converting it SQL and retrieve result from Bigquery.
- Data from Bigquery will be displayed on the chat box with history appended.