Forum Discussion
You can turn any pipeline into a REST API call using a task. Take a look through this documentation and feel free to follow up with questions.
Thanks @tlikarish . Will try it out
- joel_bourgault3 years agoNew Contributor III
Hello, same question on my side, where multiple inserts occur within several MySQL snaps (so not the same server, but same need).
But maybe it is sufficient to force “autocommit=False” in these MySQL snaps: if I understand correctly, the commit will be performed only when the pipeline completes, i.e. no commit happens if the pipeline fails.
Is this understanding correct? Is this a correct way to handle this design?
This might be true if you’re inserting several records into one table
but for my usecase, i’ve been looking at inserts into different tables (e.g. a customer table, and a customer contact table) - which should be combined to fail together, which currently seems impossible without the SQL execute snap.
Related Content
- 4 months ago
- 6 years ago
- 2 years ago