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
Try moving that group by N to a child pipeline and see how it works for Ultra.
Most of the snaps (group by, group By N, aggregate snaps) work in child pipelines in Ultra mode as long as you return one document to the top level parent pipeline.
Thats a workaround we have tried, but API performance is not as good as what we expected.
From Snaplogic professional, it seems doing parent-child pipeline will add some overhead even with Ultra task.
One way of achieving faster response is to provide limit and offset to the callers using this Ultra API.
LIMIT and OFFSET can be easily implemented in database queries!
You can easily implement this and thereby dont expose the whole set of data when not needed.
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.
