Answering your question:
> Why am I getting errors? Is there more detail that can be shared on what exactly the error is?
When the error appears there can be the following:
1. If it is a record-level error(records fail for some reason: unique constraint violation, lookup fails etc.), as in your case, the information about failed records with error message texts is added to an error log. This per-record error log can be downloaded by clicking the corresponding package run in the Run History and then clicking the number of failed rows for a table.
For more information, please refer to https://skyvia.com/resources/docs/index.html?error_processing.htm
2. If it is a package-level error (package execution fails: connection issue, source error etc.), there will be no log file, and no successful record count or error record count. Instead, the error text is displayed, which explains why the package run failed. So, in this case, you can find the corresponding run in Run History and see the error text