Using sqlalchemy orm in streamlit on snowlfake

Hi :wave:,

I’m working on a Streamlit app that will be hosted on Snowflake, and I need to perform CRUD operations on several entities in my Snowflake database. I’m considering using SQLAlchemy for this. I have a few questions:

  1. Has anyone successfully used SQLAlchemy with Snowflake in a Streamlit app hosted on Snowflake? Any pitfalls to watch out for?
  2. How do you handle database migrations in this setup? Are there any Snowflake-specific considerations?
  3. Is there a better alternative to SQLAlchemy for this use case that integrates well with Streamlit and Snowflake?

Any insights, code snippets, or resources would be greatly appreciated. Thanks in advance for your help!