My sql execute snap

@alchemiz @darshthakkar

One thing i faced with all the tries is it is showing common error “Batch operation failed” i still dont know why this error is throwing,
So i have used Pipeline execute snap and updating the record in child pipeline then it is working fine.

Iam thinking the problem is with Batch operation Previously i tried with single record it worked fine.

You guys know why this error throwing Or the Mysql execute snap does not support batch operation iam confused

Share ur runtime id

In the future, if you have trouble with building a dynamic SQL string, here is a good trick to use.

At least for testing, split your work into a Mapper Snap, then the Exec SQL snap.

Build your string in the mapper snap and map it to something like $query.

Then if you want to try executing it, have the SQL Snap simply execute $query with the [=] turned on.

You can disable the SQL snap until you think you are ready. And then you can play with the expression that builds the string, using the mapper. This will let you see exactly the string you are building, and your errors will often be a LOT more obvious.

You’ll notice this is what user @alchemiz did.

Just my $0.02 of help.