Merge documents into one big document
Hi,
Currently when I use Oracle select/Oracle execute snaps to query data from Snaplogic, it will return multiple documents as output from those snaps(one row per doc).
Is there a way i can merge...
Forum Discussion
No, in our case, we have to expose all data from one select * query.
Or you could try doing the group by in python since “Script” snap does support ultra. I know this isn’t ideal but at least this might satisfy your business requirements.
I think you meant by non-ultra task with groupbyN take 3-4 seconds which I think is what we can expect. There is a reason why there is ultra which is exactly design to offer sub-seconds respond time. I believe the more sensible enhancement request is to enable more functions like GroupbyN to be supported by Utra.
IMHO
Yes, Script is the only way we can do this which can provide faster performance as well.
But we would avoid to use script or any snap development. That defeat the purpose of ‘Citizen integration’ as what Snaplogic advertised.What is your expectation in terms of time and results?
200 docs in 1 sec or 3 secs or subseconds?
What config do you have? How many nodes/FMs?
#enhancement_request
So we got a script written by your professional. the whole pipeline with this script snap and ultra task only takes 200ms.
Remember when I say we used ultra task with groupbyN snap and Pipeline execute, it takes 3 to 4s.
Something definitely need a enhancement request. Performance is bad.
Yes, we have asked for a request
I do have similar issue. is it possible to share the script
