Links

Amazon Redshift

This page describes the job options for writing your data to Amazon Redshift.
The following job options are used when writing to Amazon Redshift tables. Please note that tables and columns must exist prior to the job being created. Upsolver cannot create a new Amazon Redshift table or column but can alter existing ones.

Syntax

[ AGGREGATION_PARALLELISM = <integer> ]
[ COMMENT = '<comment>' ]
[ COMPUTE_CLUSTER = <cluster_identifier> ]
[ END_AT = { NOW | timestamp } ]
[ FAIL_ON_WRITE_ERROR = { TRUE | FALSE } ]
[ RUN_INTERVAL = <integer> { MINUTE[S] | HOUR[S] | DAY[S] } ]
[ RUN_PARALLELISM = <integer> ]
[ SKIP_FAILED_FILES = { TRUE | FALSE } ]
[ START_FROM = { NOW | BEGINNING | timestamp } ]

Jump to

Amazon Redshift job options:
General job options:

Job options

FAIL_ON_WRITE_ERROR

Type: boolean
Default: false
(Optional) When true, the job will fail when an on-write error occurs.

SKIP_FAILED_FILES

Type: boolean
Default: true
(Optional) When true, the job will skip any files in which the job is unsuccessful and continue with the rest of the files.