Pipeline to Search 130k Records in Another App and Create if the Record Does Not Yet Exist

What if you have the Pipeline create a Bulk Upsert, and add the one new row to it for the newly created record, and then commit the upsert for that one record.  It will either edit the existing record or add a new one if it does not exists.  If you are just creating one field in table B, then the upsert for an existing record will do nothing, as it already exists.

Since the Login ID in table B is unique, you should be able to use it as a Merge field for the Bulk Upsert.

Thanks Mark! I'll research this and give it a shot. Thanks for the quick help! 

My Advanced Query continues to return an error:

{{ a.create_date - time.delta(days=1) }}

Validation error: Incorrect template "{{ a.create_date - time.delta(days=1) }}". TypeError: unsupported operand type(s) for -: 'NoneType' and 'relativedelta'

I'm trying to search for Client records that were created yesterday and add those to my upsert. 

I need to search through over 130k records to see if it exists before adding the new record and that takes so much time.