## Metadata - Author: [[amaresh-m|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](https://read.readwise.io/read/01j63244p2kjpaywrrrtw56vpk)) > 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](https://read.readwise.io/read/01j6324yx2wtgqwgrvycdzaa09))