Amazon Redshift
The following job options are used when writing to Amazon Redshift tables. Upsolver will create missing tables in Redshift.
Job options
Jump to
Amazon Redshift job options:
General job options:
AGGREGATION_PARALLELISM
— editable
AGGREGATION_PARALLELISM
— editableType: integer
Default: 1
(Optional) Only supported when the query contains aggregations. Formally known as "output sharding."
FAIL_ON_WRITE_ERROR
FAIL_ON_WRITE_ERROR
Type: Boolean
Default: false
(Optional) When true
, the job will fail when an on-write error occurs.
SKIP_FAILED_FILES
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.
TRUNCATE_COLUMNS
TRUNCATE_COLUMNS
Type: Boolean
Default: false
(Optional) When true
, data is truncated when inserting into an existing table containing VARCHAR
or CHARACTER VARYING
columns smaller than the incoming data size, to prevent the insert from failing.
When false
, the insert fails if the incoming data is larger than the target column and SKIP_FAILED_FILES
is also false
.
Last updated