Vanna.ai not supporting multi-line strings in training data

vanna-ai / vanna

🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.

https://vanna.ai/docs/

MIT License

9.12k stars 673 forks source link

Vanna.ai not supporting multi-line strings in training data #500

Closed MelzCoss closed 1 week ago

MelzCoss commented 2 weeks ago

It seems that Vanna is no longer supporting multi-line strings is training data, like:

vn.train(documentation=""" Some informations.. """)

In facts this type of documentation is not added in the prompt. Any suggestions?

Marck100 commented 2 weeks ago

Same problem

zainhoda commented 2 weeks ago

I don't see this issue. What setup are you using?

Screenshot 2024-06-18 at 8 25 14 AM

MelzCoss commented 2 weeks ago

I don't see this issue. What setup are you using?

I apologize for not explaining myself well. The DDL documentation is inserted in the training data, however when generating the query I see that the prompt is missing the DDL part after "===Tables", consequently the generated queries cannot be based on a schema. The problem started from version 0.5.5 of Vanna, I solved it by installing 0.5.4.