Posted by Hugi Thordarson

If you want to write directly to a file, just do:

@export on;
@export set filename="/tmp/bigassquerydata.csv";

select * from huge_table

The default format of the outputted data is CSV, but you can specify a different format by adding a 'format' parameter to the @export directive, like so:

@export on;
@export set filename="/tmp/bigassquerydata.sql"  format="sql";

select * from huge_table

More information in DBVisualizer's documentation.