Label | Required. User provided label for the account instance |
---|
JDBC Driver Class | Name of the JBDC driver class to use. Default value: org.postgresql.Driver
|
---|
JDBC jars | The list of JDBC jar files to be loaded. The user can upload the Redshift driver(s) that can override the default org.postgresql.Driver driver. Note |
---|
Set the Batch size property to 1 with the JDBC driver version RedshiftJDBC41-1.1.10.1010.jar. |
Default value: [None] |
---|
JDBC Url | The Url of the JDBC database. Example: jdbc:redshift://hostname:port/database Default value: [None] |
---|
Account properties | Required. Enter in the information to create a connection to the database. |
---|
Endpoint
| Required. The server's address to connect to. Default value: [None] |
---|
Port number | Required. The database server's port to connect to. Default value: 5439 |
---|
Database name | Required. The database name to connect to. Default value: [None] |
---|
Username | Username that is allowed to connect to the database. Username will be used as the default username when retrieving connections. The username must be valid in order to set up the data source. Default value: [None] |
---|
Password | Password used to connect to the data source. Password wil be used as the default password when retrieving connections. The password must be valid in order to set up the data source. Default value: [None] |
---|
S3 Bucket | S3 Bucket to use for staging data onto Redshift. Note |
---|
This field is required if the IAM role checkbox is enabled in the Bulk Load Snap. For optimal performance, this S3 bucket should be located in the same AWS region as the Redshift instance. |
Default value: [None] |
---|
S3 Folder | Relative path to a folder in S3 Bucket. This is used as a root folder for staging data onto Redshift. Default value: [None] |
---|
S3 Access-key ID | S3 Access key ID part of AWS authentication. Note |
---|
This field is required if IAM role checkbox is enabled in the Bulk Load Snap. |
Default value: [None] |
---|
S3 Secret key | S3 Secret key part of AWS Authentication. Note |
---|
This field is required if IAM role checkbox is enabled in the Bulk Load Snap. |
Default value: [None] |
---|
KeyStore | The location of the key store file, can be in SLDB or any other unauthenticated endpoint such as https://... Example: shared/client_keystore.jks Default value: [None] |
---|
TrustStore | The location of the trust store file, can be in SLDB or any other unauthenticated endpoint such as https://... Example: shared/client_truststore.jks Default value: [None] |
---|
Key/Trust store password | Password for key/trust store, it is used for both if both are defined.
Default value: [None] |
---|
Key alias | Define the key being used via its alias
Default value: [None] |
---|
IAM properties |
---|
AWS account ID | ID of the Amazon Web Services account to be used for performing bulk load operation. Note |
---|
This field is required if IAM role checkbox is enabled in the Bulk Load Snap. |
Default value: [None] |
---|
IAM role name | Name of the IAM role that has been assigned to the redshift cluster to access the S3 bucket provided above. Note |
---|
This field is required if IAM role checkbox is enabled in the Bulk Load Snap. |
Default value: [None] |
---|
Region name | Name of the region the Redshift cluster belongs to. Default value: [None] |
---|
Advanced properties |
---|
Auto commit | Required. If selected, then batches are immediately committed after they execute. Therefore, only the current executing batch will be rolled back if the Snap fails. If not selected, then a transaction is started for the Snap run and committed upon run success. The transaction will be rolled back if the Snap fails. Default value: Selected |
---|
Batch size | Required. Number of statements to execute at a time. Note |
---|
Set the Batch size property to 1 with the JDBC driver version RedshiftJDBC41-1.1.10.1010.jar, in the JDBC jars. |
Note |
---|
Select queries are not batched. |
Warning |
---|
User-defined types won't be supported if a JDBC driver with a version other than 11.2.0.4.0 is set. |
Default value: 50 |
---|
Fetch size | Required. Number of rows to fetch at a time when executing a query.
Warning |
---|
User-defined types won't be supported if a JDBC driver with a version other than 11.2.0.4.0 is set. |
Default value: 100 |
---|
Max pool size | Required. Maximum number of connections a pool will maintain at a time.
Note |
---|
Redshift Bulk Load/Bulk Upsert/S3 Upsert Snap requires a minimum of 2 connections per Snap in a pipeline. For example, if a pipeline has a Redshift Bulk Load Snap and an S3 Upsert Snap, then the pool size must be greater than or equal to 4 for successful execution. |
Default value: 50 |
---|
Max life time | Required. Maximum lifetime of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed. Default value: 30 |
---|
Idle Timeout | Required. The maximum amount of time a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool. Default value: 5 |
---|
Checkout timeout | Required. Number of milliseconds to wait for a connection to be available when the pool is exhausted. Zero waits forever. An exception will be thrown after the wait time has expired. Default value: 10000 |
---|
URL Properties |
---|
URL property name | URL property name Default value: [None] |
---|
URL property value | URL property value Default value: [None] |
---|