In this article

...

Use this account type to connect Redshift Snaps with data sources.

Prerequisites

Access to the following folders:

• Private project folder
• Project Space’s shared folder
• Global shared folder

Limitations

None.

Known Issues

None.

Account Settings

...

Image Added

Insert excerpt
Redshift Snap Pack Redshift Snap Pack nopanel true

Parameter	Data Type	Description	Default Value	Example
Label*	String	Required. Unique Unique user-provided label for the account.	N/A
JDBC Driver Class	String	Name of the JBDC driver class to use.	org.postgresql.Driver
JDBC jars	String	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. Set the Batch size property to 1 with the JDBC driver version RedshiftJDBC41-1.1.10.1010.jar.	N/A
JDBC Url	String	Enter the Url of the JDBC database.	NA	jdbc:redshift://hostname:port/database
Account properties	Required. Enter in the information to create a connection to the database.
Endpoint*	String	Required. Enter Enter the server's address to connect to.	NA	fieldcluster.c8dwbwr9.us-east-1.redshift.amazonaws.com
Port number*	Numeric	Required. Enter the database server's port to connect.	5439
Database name*	String	Required. Enter thethe database name to connect.	NA	snaplogic
Username	String	Enter the username 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.	NA	redshiftadmin
Password	String	Enter the password used to connect to the data source. Password will be used as the default password when retrieving connections. The password must be valid in order to set up the data source.	NA	p@$$20d*
S3 Bucket	String	Enter the external S3 Bucket name residing in an external AWS account, to use for staging data onto Redshift. Note This field is required when using Redshift Bulk Load, Redshift Bulk Upsert, Redshift S3 Upsert, and Redshift Unload Snaps.	NA	test
S3 Folder	String	Enter the relative path to a folder in S3 Bucket. This is used as a root folder for staging data onto Redshift.	NA
S3 Access-key ID	String	Enter the S3 Access key ID part of AWS authentication. Note This field is required when using Redshift Bulk Load, Redshift Bulk Upsert, Redshift S3 Upsert, and Redshift Unload Snaps if the IAM role checkbox is not selected.	NA
S3 Secret key	String	Enter the S3 Secret key part of AWS Authentication. Note This field is required when using Redshift Bulk Load, Redshift Bulk Upsert, Redshift S3 Upsert, and Redshift Unload Snaps if the IAM role checkbox is not selected.	NA
IAM properties	Specify the IAM properties information for Redshift to communicate with IAM.
AWS account ID	String	Enter the ID of ID of the Amazon Web Services account to Services account to be used for performing bulk load operation. Note This field is required when using Redshift Bulk Load, Redshift Bulk Upsert, Redshift S3 Upsert, and Redshift Unload Snaps if the IAM role checkbox is selected.	NA
IAM role name	String	Enter the name of the IAM role that has been assigned to the  redshift Redshift cluster to access the S3 bucket provided above. Note This field is required when using Redshift Bulk Load, Redshift Bulk Upsert, Redshift S3 Upsert, and Redshift Unload Snaps if the IAM role checkbox is selected.	NAN/A
Region name	String	Enter the name of the region the Redshift cluster.	NAN/A	us-east-1
Advanced properties	Specify advanced properties to support this account.
Auto commit	Checkbox	Select this check box to enable the Snap to commit offsets automatically as messages are consumed and sent to the output view.	Selected	N/A
Batch size*	Numeric	Required. Enter Enter the 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. Select queries are not batched. User-defined types won't be supported if a JDBC driver with a version other than 11.2.0.4.0 is set.	50	50
Fetch size*	Numeric	Required. Enter Enter the number of rows to fetch at a time when executing a query. Note User-defined types won't be supported if a JDBC driver with a version other than 11.2.0.4.0 is set.	100	100
Max pool size*	Numeric	Required. Enter Enter the 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.	50	30
Max life time*	Numeric	Required. Enter the 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.	30	10
Idle Timeout*	Numeric	Required. Enter 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.	5	6
Checkout timeout*	Numeric	Required. Enter the 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.	1000	800
URL Properties	Specify the URL properties associated with this account.
URL property name	Numeric	Enter the URL property name	NA	ssl
URL property value	Numeric	Enter the URL property value	NA	true

Troubleshooting

None.

...

See Also

...