Hi,
For your scenario, I would like to let you know that “Verify return results: i.e. Estimated row count” in the presentation indicates a test mainly done to check the health of the base view. The Base view health check here means whether the base view tested is in executable condition and thereby checks if the Data source is accessible(base view can be executed only if the Data source has a valid connection).
Since it is just a test to check the executability of the base view, we could use a LIMIT clause to limit the number of results returned instead of returning the complete result of the base view and could see if the test passes.
To test the health of the multiple base views (bulk check) you can always configure multiple queries along with their corresponding results separately in the same test file as mentioned in the example below.
Then, you can run the sample file configured to test the health of the multiple base views configured in it as a single go.
For example, in a sample test file you can configure various base views with their corresponding results like below,
> %EXECUTION[query]
{ ds:vdp }
select id,first_name from <database_name>.bv_student limit 2;
#--------------------------------------------------
%RESULTS[data]
id,first_name
1,Joe
2,Chris
#----------------------------------------------------
> %EXECUTION[query]
{ ds:vdp }
select customer_id,customer_name from<database_name>.bv_cc_customer limit 1;
#------------------------------------------------------
%RESULTS[data]
customer_id,customer_name
1,Laura
You can also configure the input query and results set as a file format like below. This can be helpful for bulk validation.
> %EXECUTION[script]
{ ds:vdp }
file:<File_path>\<Filename>.vql
#-----------------------------------------------------
%RESULTS[csv]
{ type:full }
file:<File_path>\<Filename>.csv
**Note: The “%RESULTS[data]” results should be in the same order as the expected result for the validation to pass.**
For more information refer to [Denodo Testing Tool](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Testing%20Tool%20-%20User%20Manual) - User Manual.
Hope this helps!!
