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. Upsolver will create missing tables in Redshift.

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:

• FAIL_ON_WRITE_ERROR

• SKIP_FAILED_FILES

General job options:

• AGGREGATION_PARALLELISM

• COMMENT

• COMPUTE_CLUSTER

• END_AT

• RUN_INTERVAL

• RUN_PARALLELISM

• START_FROM

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.