Amazon Redshift

Agile Data Engine supports:

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.