Amazon Redshift Writer Parameters
Database Connections
Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Using Database Connections. Note that Database Connection parameters may differ slightly, depending on context and/or database format. |
Select an existing connection, or Add Database Connection to define a new connection.
The new connection can be made visible only to the current user, or can be shared among multiple users.
Connection Parameters
This specifies the machine running the Redshift ORDBMS as either an IP address or host name. The database must have proper permissions and be set up to accept TCP/IP connections if connecting from a remote machine.
When connecting remotely, this specifies the TCP/IP port on which to connect to the ORDBMS service. The default port is 5439.
This specifies the name of the Redshift database. The database must exist in the ORDBMS.
Enter the username and password to access the service.
Advanced
The number at which the writer will start writing features into the database. The writer skips the number of features in this parameter, and then it begins writing the features that follow.
Usually, the value specified is 0 (this is the default) – a non-zero value is usually only specified when a data load operation is being resumed after failing partway through.
The number of features that FME places in each transaction before a transaction is committed to the database.
The default value is 1000.