Ask BigQuery

• 

  Ask "get the top 3 product which generated revenue in 2023" on the iowa_liquor_sales public dataset

• 

  Input the beginning of a SQL query and the app completes it

Inspiration

• Google Cloud Blog Integrating BigQuery data into your LangChain application and the corresponding notebook
• BigFunctions with the ask_my_data BigQuery UDF

What it does

Let's you ask your BigQuery data any question in natural language from a chat interface. The user prompt is send to an LLM to generate a SQL query which is then run on BigQuery directly.

How I built it

Built with Streamlit, LangChain & VertexAI.

Built With

• langchain
• python
• streamlit
• vertexai