Versions Compared

Old Version 12

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version 13

changes.mady.by.user Sandhya Sriram

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

The default JDBC URL jdbc:postgre:://<hostname>:<port>/<db> does not work, because it is not compatible with JDBC 2.x drivers. If you are using 2.x version of Amazon Redshift drivers, you must explicitly provide the JDBC URL as shown:
jdbc:redshift://<hostname>:<port>/<db> to configure the account successfully.

Known Issues

None.

Account Settings

Image RemovedImage Added


FieldField TypeDescription

Label*

Default Value: N/A
Example: Redshift Account

String

Specify a unique label for the account.

JDBC Driver Class

Default Value: org.postgresql.Driver
Example: org.postgresql.Driver

String/Expression

Specify a name of the JBDC driver class to use.

JDBC jars

Default Value: N/A
Example: org.postgresql.Driver

String/Expression

Specify a list of JDBC jar files to be loaded.

Info

You 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.


JDBC Url

Default Value: N/A
Example: jdbc:redshift://hostname:port/database

String/Expression

Enter the Url of the JDBC database.

Info

If you are using 2.x version of Amazon Redshift drivers, you must explicitly provide the JDBC URL as jdbc:redshift://<hostname>:<port>/<db> to configure the account successfully. The default JDBC URL, jdbc:postgre://<hostname>:<port>/<db> does not work as it is not compatible with JDBC 2.x drivers.


Account properties*

Enter in the information to create a connection to the database.

Endpoint*

Default Value: N/A
Example: fieldcluster.c8dwbwr9.us-east-1.redshift.amazonaws.com

String/Expression

Enter the server's address to connect to.

Port Number*

Default Value: 5439
Example: 5439

Numeric/Expression


Enter the database server's port to connect.

Database name*

Default Value: N/A
Example: snaplogic

String/Expression

Enter the database name to connect.

Username

Default Value: N/A
Example: redshiftadmin

String/Expression

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.

Password

Default Value: N/A
Example: p@$$20d*

String/Expression

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.

S3 Bucket

Default Value: N/A
Example: sl-bucket-ca

String/Expression

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. 


S3 Folder

Default Value: N/A
Example: s3://sl-bucket-ca/san-francisco

String/Expression

Enter the relative path to a folder in S3 Bucket. This is used as a root folder for staging data onto Redshift.

S3 Access-key ID

Default Value: N/A
Example: NAVRGGRV7EDCFVLKJH

String/Expression

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. 


S3 Secret key

Default Value: N/A
Example: 2RGiLmL/6bCujkKLaRuUJHY9uSDEjNYr+ozHRtg

String/Expression

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. 


S3 Security Token

Default Value: N/A
Example: FwoGYXdzEGUaDFInugbfGX8xlGA4ZwNWCi
V3uSQBjIre4G7AXvfuGO2Fq41wDp7cLCuGAZvKGc4T
cSknLVYpI2amWKf9z21+7oszQ==

String/ExpressionSpecify the S3 Security token part of AWS Authentication for using temporary credentials (AWS STS).
IAM propertiesSpecify the IAM properties information for Redshift to communicate with IAM
.


AWS account ID

Default Value: N/A
Example: AWS-1

String/Expression

Enter the ID of the Amazon Web 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. 


IAM role name

Default Value: N/A
Example: rolex

String/Expression

Enter the 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 when using Redshift Bulk Load, Redshift Bulk Upsert, Redshift S3 Upsert, and Redshift Unload Snaps if the IAM role checkbox is selected. 


Region name

Default Value: N/A
Example: us-east-1

String/Expression


Enter the name of the region the Redshift cluster.
Advanced propertiesSpecify advanced properties to support this account.

Auto commit

Default Value: Selected
Example: Deselected

Checkbox


Select this check box to enable the Snap to commit offsets automatically as messages are consumed and sent to the output view.

Batch size*

Default Value: 50
Example: 50

Integer/Expression

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.


Fetch size*

Default Value:100
Example:100

Integer/Expression

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.


Max pool size*

Default Value: 50
Example: 30

Integer/Expression

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.


Max life time*

Default Value: 30
Example: 10

Integer/Expression

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.

Idle Timeout*

Default Value: 5
Example: 6

Integer/Expression

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.

Checkout timeout*

Default Value:1000
Example: 800

Integer/ExpressionEnter 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.
URL PropertiesSpecify the URL properties associated with this account.

URL property name

Default Value: N/A
Example: ssl

String/Expression


Enter the URL property name.

URL property value

Default Value: N/A
Example: true

String/Expression


Enter the URL property value.


Insert excerpt
Redshift Snap Pack
Redshift Snap Pack
nopaneltrue

...