Search code examples
sqlamazon-redshiftsql-workbench-j

SQL Workbench WbExport to two locations for Redshift

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;
Solution

  • 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