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.