To test the Solvent Inventory E2E we are going to introduce mistakes in a solvent experiment and wait for the errors to be sent in the CGP error_logs. To do so you can clone a solvent experiment in ELN TEST, and edit the Excel file. And modify the solvents name by adding caracters, delete caracters and also use the synonyms of the solvent (findable here : )

Then you ask to the data ing to ingest your ELN solvent experiment, and also to run the jobs in order to the the mail for an E2E test ! After that, put next to each other your experiment solvents, the inventory and the result found in the email.

Example : 

In Green = Errors detected successfully

In Red = Errors detected, but are false positive...

In Blue = Proofs that Synonyms are working

(left is the solvent experiment, middle in the inventory, right in the email)

Then you can check with a data eng line by line, until all the incorrect lines are not present anymore in GCP. Example of request :

SELECT * FROM `prj-data-dm-ri-dev.DM.log_errors` WHERE experiment_id LIKE "1811864"