Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hi folks, I'm new to prefect. I've just written my SQLAlchemy models, hoping to query them from a `@task`, but I wrote the models using SQLAlchemy v2, and it looks like Prefect depends on v1.4. Is it not possible to use the latest SQLAlchemy version for my models with Prefect?

see <https://github.com/PrefectHQ/prefect/issues/8052>

Thanks <@U03LH98F8S2> I did see that, but assume dit was about upgrading Prefect's codebase to use SQLAlchemy v2. My question was whether I was limited to v1.4 in my workflow files, which I appreciate may be obvious to someone who's done more work in Python (it's been a while for me!)

If you’re running the server elsewhere or using Prefect Cloud you can use a newer version of SQLAlchemy

We only use if it we’re running the server/API — however, it is feasible that we make some calls on import that won’t be supported so I can’t say for sure.

If you do encounter problems, we’d be happy to help fix them.

Thanks Zanie. I haven't gotten to the point of deploying yet, so I don't quite understand how I could "run the server elsewhere" - I'll dig in to the docs on those concepts in a bit. For now, I've translated my model over to sqlalchemy v1.4 - thanks for clarifying though!

:+1: we run the API in-memory whenever you run a flow without setting an API URL