Get source associations

We want to get the associations between companies, deals and line items so we can write these associations to Hubspot later on.

We have a single Flow that handles this.

Both rows do the same thing, so let's just focus on the first row, which gets the associations between customers and orders.

1. We clear out the assoc-company-deal entries form the Ziggy Data Store.

2. We run a SQL query. Note that this is a Batched operation as there could be a huge number of orders, and we need to read the data in chunks. We have specified 1000 rows per batch.

3. We write the data to the Data Store.

4. These steps will loop until all rows have been read.