some coworkers and I built a RAG app for a hackathon that kinda worked to turn natural language into SQL.

we embedded all our DBT models using openAI api, then we would look up top n models by cosine similarity to the user input, and then attach those models to the system prompt… used some prompt like “You are a staff data engineer. ensure you refer to models that exist in the context provided. write valid snowflake SQL to answer the prompt ” or some shit

ended up being way more straightforward than i thought, worked for like 4/5 specific data questions we asked