I had a Drupal 8 migration where there was some data that was available, but not available from the source DB. However, I was able to get this data in a separate CSV file and a value in the source db was available in this CSV file also. So I had a way around the issue.

This plugin allows for the CSV file to be parsed, cached and queried for a single column allowing for the single file to be used for multiple fields.