How do I avoid multiple select requests
I have multiple data-stores and need to hydrate data pulled from one with data from another.
The issue is that if I have two independent staring snaps perform the queries, I would have to pull ever...
Forum Discussion
Ah, I forgot there’s a Lookup snap that will batch multiple input documents into a single SELECT query with a WHERE clause that is dynamically generated. That might work better for you.
Thanks for the feedback!
I am receiving an error using your expression, it seems to not like a BigInteger type:
I think this may work with a little adjustment though. I tried converting each id into a string value first, but it seems that this error is thrown on the arr.length which isn’t referencing the value but rather the array itself.
This is the output of the snap feeding my query snap: (if it helps)
I have not been able to find a way to turn this into an array to pass in.
As far as the Redshift Lookup snap, I will have to take the time to configure the connections as it looks like I will have to create a SnapLogic IAM role and everything. There is also the added cost of the Redshift snap pack just to do a simple select statement that I have to make sure my higher-ups are ok with.
Also, I have need to do this type of query into MSSQL and MySQL databases as well so the Redshift snaps wouldn’t help much there. It would be nice to have a way to expose or pass in the document array itself to another snap, or to the expr file for more control.
Thanks again for all of the help.
