I have a Database Connector that writes permission data to a custom table that is going to be used for Power BI reporting. However, when the connector script is run in PY it gives different results to DV when run over the same test data. The screenshot shows, obfuscated, what is happening:

The script uses the email address to retrieve the Active Directory ID and Active Directory Display Name which are then populated onto the table. I have confirmed that the script is the same and shared in both DV and PY:

The R74PNAM and UUID columns have been added to the table as part of this change. Our CNC support team have confirmed that the specifications are correct and match in both the DV and PY environments. Has anybody had similar issues or any suggestions as to what to look at next? As a test I swapped the ${name} and ${adid} around and the issue was reversed, i.e. wrong in DV and correct in PY.