Forum Discussion

maahutch's avatar
maahutch
New Contributor
2 years ago

Conditional delete from a databases using a value from the pipeline

I'm trying to delete rows from my database when their id's aren't in the response document returned from an api query. Currently, my pipeline looks like this: If there is an ID value in the SQ...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
2 years ago

maahutch 

On Validation mode, the pipeline is working only with subset of records(1 to 2000 records), depending what you have selected in the User settings. 

So, probably that subset of records does not meet the condition in the delete statement. 

Try to execute the pipeline. And also check the Snap Execution Mode of the SQL Server Execute Snap. 

BR,

Spiro Taleski