Skip to main content
Open

Idea: cancelling a job will rollback the whole transaction of all features for Snowflake Writer

Related products:FME FormIntegrations
  • December 15, 2025
  • 2 replies
  • 42 views

lauryn00789
Participant
Forum|alt.badge.img+2

Idea: cancelling a job will rollback the whole transaction of all features for Snowflake Writer

Observed behavior: cancelling a job in FME Flow will stop additional features from being written, but features that have already been written to Snowflake are already committed without any rollback of the transaction. There is inconsistency between “Features Written’ as recorded in the job log and actual features written according to Snowflake logs. The job log records zero features written while there have been many features written to Snowflake despite job being cancelled.

Desired behavior: cancelling a job in FME Flow will stop additional features from being written and rollback any partial changes the job has just done. 

Outcome: improved management of jobs.

2 replies

PierreAtSafe
Safer
Forum|alt.badge.img+8
NewOpen

PierreAtSafe
Safer
Forum|alt.badge.img+8

@lauryn00789 Hello and happy new year!

After a quick review with the developers the discrepancy between the number of features written in the job log and the actual features written by Snowflake sounds like a defect. We would be interested in a workspace to reproduce this issue if you can share something with us? Feel free to dm me.

The translation rollback would be a bit trickier and might be achieved using the Advanced → Features per Transaction parameter in the writer, but that depends on the performances of the machine running the translation and how many features you want to write.

Not sure how feasible it would be to rollback transactions that have already been committed to Snowflake. The Job cancellation is more of a “Job stop” in that regard, not a “Job stop & rollback”.

I’m also curious to know what is the reason leading you to cancel a translation on Flow in a normal application? Is it for workspace development/testing purposes?

Cheers