Hi All,
Has anyone been able to call a redshift stored proc using Snaplogic, couple of items which I read on the community mentioned they were not able to do so and there is an enhancement request for the same. If anyone one has an idea regarding how to achieve this, please let me know in the comments.
Thanks and Regards
Anubhav
An Ultra Pipeline with unlinked input/outputs will receive requests for processing from the Feed-Masters in the Snaplex. The requests are stored in queues on the Feed-Masters until they are processed by the Ultra pipeline executions. If an execution fails while processing a request, possibly because a snap fails or if the node the execution is running on crashes, another execution will try to process the request. A request will be retried 5 times before the request is considered to be a “poison pill” and is dropped. (The request is dropped to ensure that it does not block other requests from being processed.)
As to what kind of failures there can be, the error views are automatically added to snaps in an Ultra execution, so it depends on the type of snap and error as to whether it will fail the pipeline versus writing to the error view.
