Untitled

How to automate a test that queries from a large database? (import or create)
public static void main(final String args) {
  final DatabaseConnection conn = new DatabaseConnection(getConnectionToDbWithRealData());
  final QueryDataSet dataset = new QueryDataSet(conn);
  dataset.addTable("foo", "select * from foo where bar = 'xyz'");
  new CsvDataSetWriter(getOutputFile()).write(dataset);
}

CREATE TABLE foo (
  ...
) AS SELECT * FROM CSVREAD('classpath:/foo.csv', null, 'null=null');