LangChain SQL agent to query Google Cloud BigQuery using the Gemini Generative AI through Vertex AI

To demonstrate how to use a LangChain SQL agent to query Google Cloud BigQuery using the Gemini Generative AI through Vertex AI. I have seen apps with Open AI and I wanted to make with Gemini

** It's easy to deploy and easy to use with langchain sql agent in order to query and see the results of sensordatas which are crucial for daily industrial life. It's useful especially for non-tech users like managers and executives to see the results of datas obtained by sensors just by asking with good prompts.**

First, I obtained the sensordatas from Kaggle Datasets. Then I asked Gemini to help me write code but it was for OpenAI and I managed to use with Gemini Generative AI through Vertex AI with Langchain SQLAgent.

The example code was for OpenAI first I tried to use with Vertex AI text-bison but it was difficult to make queries many times due to quota that's why I tried to use with Google Gen AI with Gemini-pro. In addition with Gemini-pro I can ask in Turkish althoug the reply is in English the results are correct.

To be able to query also in Turkish, within seconds in order to get correct results via Gemini.

User friendly sql agent, easy to deploy and see the great results. If you want to accomplish every problem is a great opportunity. Also the future is bright and I think that it would be great to have agents section in vertex AI.

What's next for Analyzing Datas with AI Agents on Vertex AI

Built With

• gemini
• generativeai
• google-bigquery
• langchain
• python
• sqlagent
• sqlalchemy