The directives that are processed by the Redshift writer are listed below. The suffixes shown are prefixed by the current <WriterKeyword>_ in a mapping file. By default, the <WriterKeyword> for the Redshift writer is REDSHIFT_OUT.
DATASET/DATABASE, HOST, PORT, USER_NAME, PASSWORD
These directives operate in the same manner as they do for the Redshift reader.
START_TRANSACTION
Required/Optional: Optional
This statement tells the Redshift writer module when to start actually writing features into the database. The Redshift writer does not write any features until the feature number of features are skipped, and then it begins writing the following features. Normally, the value specified is zero – a non-zero value is only specified when a data load operation is being resumed after failing partway through.
REDSHIFT_OUT_START_TRANSACTION 0
Workbench Parameter: Starting Feature
TRANSACTION_INTERVAL
Required/Optional: Optional
This statement informs the FME about the number of features to be placed in each transaction before a transaction is committed to the database.
If the REDSHIFT_OUT_TRANSACTION_INTERVAL statement is not specified, then a value of 1000 is used as the transaction interval.
REDSHIFT_OUT_TRANSACTION_INTERVAL 2000
Workbench Parameter: Features Per Transaction