SQL Workbench WbExport to two locations for Redshift

103 views Asked by At

Is it possible to export to two locations using WbExport for Redshift. Or is there an alternative method without having to change the file path.

WbExport -file = 'file_path1'
-type=text
-delimiter=,
-header=true;
1

There are 1 answers

0
AudioBubble On BEST ANSWER

No, this is not possible with SQL Workbench/J

You need to run two WbExport commands with different file names.

An alternative is to run it once, then use WbSysExec to copy the generated file to the second location