Metadata
- Author: Amaresh M
- Full Title:: Hermes: A Text-to-SQL Solution at Swiggy
- Category:: 🗞️Articles
- URL:: https://www.blef.fr/r/45b3dadc?m=110e62bb-0c8f-4516-ae23-b43d96d3f9ac
- Finished date:: 2024-08-25
Highlights
Few-shot SQL retrieval: As part of a different initiative, we maintain ground-truth / verified/ reference queries for several key metrics. We use a vector-based few-shot retrieval to fetch relevant reference queries to aid the generation process. (View Highlight)
We found that the V2 iteration of Hermes performed significantly better for charters with well-defined metadata and a relatively smaller number of tables. (View Highlight)