Unit tests
Unit test your pipe output for different use case scenarios and improve your pipe quality.
Create and manage unit test cases for your pipes in Varicent ELT with Unit testing. Create one or more test cases for the pipe Export nodes to verify the outputs. Upload test data as the input to the pipe and expected results against the Export node. This data will obtain a live comparison of the actual and expected results in the row viewer. Test case status will automatically be marked as Pass or Fail based on matching of expected and actual results.
You can also run the tests cases without uploading any expected results. In this case, the test case status shows Review required until you change it manually to Pass. Change the status at any point in the process of building the pipe. Changing the status from Review required to Pass will store a snapshot of the current results of the pipe. The saved snapshot result will be used as your expected results for all future test runs, and will allow the automatic marking of a test case as Pass or Fail.
Note
Currently, you can only upload Excel and CSV files for both test data and expected results. The test data is limited to 100 rows.
After you run the unit test, there are three possible outcomes for the test case:
Pass: The output of the pipe is as desired. The output either matches the uploaded expected result, or you have deemed the output to be as desired by manually passing the test.
Review required: The output requires reviewing to continue. This status is only possible when you have not uploaded an unexpected result. You have to review the output of the pipe export and make any necessary adjustments to the pipe logic to get your desired output. After the desired output is obtained, you can manually change the test case status to
Pass.Fail: The output of the pipe is not as desired. The output does not match the expected results that you uploaded.
Summary of test cases
The summary of all of your test cases in your organization is available in the Tests summary tab, located on the Pipes page. You can view the status of all test cases in your organization. You can also initiate a run for your test cases.