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 All,

I need help on prefect-sqlalchemy. I am using its execute() and execute_many() method to perform DML operations on the database.
When I run my flow from Python script on local, everything is working fine. But when I ran it inside docker container, DML operations are successful in the logs but changes are not reflecting in the Postgres database. However, when I use fetch_all() to select the records I am successfully able to get the records from the database.

Has anybody faced such issues?

I am using following versions
```psycopg2-binary == 2.9.6
prefect-sqlalchemy == 0.2.4```
Driver :  POSTGRESQL_PSYCOPG2

hi Nitin, when you say you see the DML operations successful in the logs, what do you mean?  are there logging statements around the DML operations or are you seeing them actually getting executed?

I’m unfamiliar with `prefect-sqlalchemy`, but when I’ve run into stuff like this in the past, I had some `autocommit` type value set to TRUE on in one environment but set to FALSE in another, so that might be worth taking a peek into