CODEWITHSUNDEEP
sqlamazon-redshiftsql-workbench-j
IOIOIOIOIOIOI
IOIOIOIOIOIOI

Reputation: 287

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;

Upvotes: 0

Views: 108

Answers (1)

user10047216
user10047216

Reputation:

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

Upvotes: 0

Related Questions