Here we will go through the steps for creating Query Compare Test Case in ETL-Validator using Apache Drill Connection as Data Source.


In order to learn how to install Apache Drill or how to set up Apache Drill as Data Source, please refer to the link -

Creating Apache Drill Connection in ETL Validator


Pre-requisite: Create a DataSource of Apache Drill connection named as 'ApacheDrill'.


Step1: Select 'ApacheDrill' as source and target connection.




  • Step2: Click '-->' (Next) and you can see the queries



  • Step3: Map the columns


  • Step4: Run the Test Case



Note: 

  • The same query can be used in other Test Cases also. For e.g. in Component Test Case.
  • In order to see more detailed step-by-step process of Query Compare Test Case, please refer to