Configuring your Redshift Account as a Data Destination

Overview

 

You can configure a new Redshift account in Fast Data Loader (FDL) by using the user credentials from your existing account in Redshift.

Prerequisites

  • Login credentials and access to Redshift account. Contact your administrator, if you do not have access or settings details.
    For more information on the Redshift account configuration, see Redshift documentation.

  • Access to Redshift Snap Pack in SnapLogic’s Intelligence Integration Platform.

Supported Versions

The Fast Data Loader is tested against Redshift 8 and may be compatible with later versions.

Account Settings

Parameter Name

Data Type

Description

Example 

Parameter Name

Data Type

Description

Example 

Create new connection tag

String

Required. Enter a name that will help identify your Oracle account in FDL.

FDL_redshift Account

Endpoint

String

Required. Enter the server address to establish a connection.

54.98.196.248

Port Number

String

Required. Enter the database server's port number to which the application must connect.

5439

Database name

String

Required. The database name to which the application must connect.

MYDB

Username

String

Required. Enter the username that you have configured for your Redshift account. The username must be valid to set up the destination endpoint.

FDL_Redshift_User

Password

String

Required. The password used to connect to the destination endpoint.

N/A

S3 Bucket

String

Required. Enter the external S3 Bucket name residing in an external AWS account, to use for staging data on Redshift.

sl-bucket-ca

S3 Folder

String

Required. Enter the relative path to a folder in S3 Bucket. This is used as a root folder for staging data on Redshift. If you want to create files at the root level, enter a forward slash '/' to the file path.

san-francisco for using s3://sl-bucket-ca/san-francisco

S3 Access-key ID

String

Required. Enter the S3 Access key ID part of the AWS authentication.

NAVRGGRV7EDCFVLKJH

S3 Secret Key

String

Required. Enter the S3 Secret key part of the AWS Authentication.

2RGiLmL/6bCujkKLaRuUJHY9uSDEjNYr+ozHRtg

See https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2111078721 to understand the process to grant access to SnapLogic FDL for Amazon Redshift.

Troubleshooting

You might encounter the following errors when you validate and save your integration:

Errors

Reason

Resolution

Errors

Reason

Resolution

Asset conflict error.

You cannot have another account in FDL with the same name. If you enter the existing account name, the Asset conflict error message is displayed.

Ensure that account name is unique. You can either click Overwrite to overwrite the existing configuration with the new one, or click Cancel and enter a unique name for your account.

Failed to validate account.

You might have entered invalid username and password.

Multiple attempts with invalid credentials may lock your account.

Ensure that you enter valid Redshift account credentials.

Contact FDL customer support at fdl-support@snaplogic.com for further assistance.

What to do next: Set up and Verify your integration, see https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486040

See Also:

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1942159838

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486040

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2004029460

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486058