1) Had to update BigQuery query we use to pull data to output the json in the format we need for sending to promote iq
2) Figured out some logging issues
3) Testing running the updated pipeline on all 6 million transactions in sandbox environment. Worked and took about 1.5 hrs.