Apis to interact with vanna RAG

[Ishankoradia]

Install vanna & its dependencies to work with a pgvector as backend & openAI as the llm service provider

1. POST api/vanna/train. By default all embeddings will be cleared and then recreated

   • Request
     • warehouse_creds
     • pg_vector_creds
     • training_sql
     • reset (default: True)
   • Response
     • task_id

2. POST api/vanna/train/check. Verifies that there is atleast 1 embedding present in the pg vector db

   • Request
     • warehouse_creds
     • pg_vector_creds
   • Response
     • success (true or false )

3. POST api/vanna/ask. Converts text to sql

   • Request
     • user_prompt
     • pg_vector_creds
   • Response
     • task_id