While in the process of running the data migration tool. We came across this error message that read: SQLSTATE: Syntax error or access violation: 1142 TRIGGER command denied to user for table ‘catalog_compare_item’. The error happened to be an access violation for Magento 1.
To clear the error message we went to MySQL® Databases in cPanel. Then next to the Magento 1 database we clicked on the privileged user. The user did not have all privileges and TRIGGER was unselected. We then granted all privileges for the Magento 1 user.
This cleared the SQLSTATE error message when running the Magento data migration tool.