We have an automation which, every night, attempts to query our SQL database for customer activity from that day and synchronize it with their related Contact objects in HubSpot.
We had a lot of success just inserting new fields, but we want to synchronize customer data (such as their Active/Inactive status) from our SQL database with their HubSpot Contact, so I am using the Upsert function, with the SQL query as the source and Hubspot as the target. For each customer with activity that day, I am performing a target lookup in Hubspot that matches a mapped-over field that we use called CustomerID provided from SQL. However, since moving over to the Upsert function, our automation was hanging for over 2 days with 0 progress, so I killed it this morning. I understand that the Target Lookup mapping function would be a little slower, but should it be "50 hours without progress" slow? Or is there something broken? The run ID for this automation is 104417530.