@Test
public void testLoadDf() throws IOException
{

    Mapping mapping = configuration.getMappings().get(0);
    
    loader.setConfiguration(configuration);
    
    loader.loadSourceFiles(mapping);
    
    assertEquals(4l, loader.loadDf(getClass().getResourceAsStream("count.sql")).first().get(0));
    
    //order by second column descending and test top row of that resultset
    Dataset<Row> dataset = loader.loadDf(getClass().getResourceAsStream("sort.sql"));
    
    assertEquals("Doctor B", dataset.first().get(0));
    assertEquals("4", dataset.first().get(1));
    assertEquals("Clinic", dataset.first().get(2));
    assertEquals("Patient 3", dataset.first().get(3));
}