[Scalabrese] Added client_session_keep_alive = True to Snowflake

vanna-ai / vanna

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

https://vanna.ai/docs/

MIT License

11.04k stars 862 forks source link

[Scalabrese] Added client_session_keep_alive = True to Snowflake #360

Closed scalabreseGD closed 5 months ago

scalabreseGD commented 5 months ago

If Vanna is running on a microservice (for example FastAPI) it can happen that the service is not running for more than 4 hours so Snowflake Token expires.

This happens when the app runs "connect_to_snowflake" at the application startup.

I would suggest to make the connection always active until the service is running otherwise the service will fail.