Breadcrumbs

Amazon Redshift

Agile Data Engine supports:

  • Amazon Redshift Serverless

  • Amazon Redshift provisioned clusters

Required connection details

The following details are required per target instance configuration:

Detail

Example

Description

Host

targetcluster.identifier.eu-west-1.redshift.amazonaws.com

Amazon Redshift endpoint. Fully qualified host name.

Database name

clouddw_dev

Default database context for the user. Must be lowercase.

Default schema

public

Default schema context for the user.

Port

5439

Default Redshift port.

Username

s_ade_dev

Service user for Agile Data Engine.

Password

••••••••

Password for the Redshift user. Securely stored and managed.

Role

arn:aws:iam::123456789101112:role/redshift-serverless-ade-role

IAM role ARN to enable S3 access for loading source data into Redshift.