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 everyone! I am just getting started with Prefect 2 - I'm excited to get started, but please let me know if this is not the right place for this question

I am trying to include a database transaction in a flow that I am creating - so the the database will be updated only if all SQL operations are successful. Basically what is described here in the Postgres documentation: <https://www.postgresql.org/docs/current/tutorial-transactions.html>

Is this possible to do with `prefect_sqlalchemy` ? I have not been able to successfully create a transaction using it.

At the moment I don’t think so (<https://github.com/PrefectHQ/prefect-sqlalchemy/blob/main/prefect_sqlalchemy/database.py#L29-L33> needs to use `begin()` instead)

in the upcoming refactor, it’ll be possible
<https://github.com/PrefectHQ/prefect-sqlalchemy/pull/35/files#diff-50a47228a8de81f7ecbf39980d60f7fa950bc54b999bd7878e3d49a0b708f9d8R311>

ok, that sounds great! Thanks so much for the update <@U0330PHG76J>