Redshift Configuration for Matillion ETL
  • Dark
    Light

Redshift Configuration for Matillion ETL

  • Dark
    Light

Overview

This guide provides a brief summary of the how new Redshift Clusters should be configured for use with Matillion ETL as launched from the Matillion Hub. It is important to note that this should be launched within the Stack created for your Matillion ETL instance and that AWS permissions may be required to complete this.

To begin, users should follow the instructions in the AWS documentation up to "Cluster Configuration".

Cluster Configuration

Redshift Node

Number of Redshift Nodes created in this new cluster, that should be 1.

Node Type

dc=Dense Compute, ds=Dense Storage. All nodes in the cluster will be the same type. You can select from the dropdown.

Master Username

Initial Redshift Username. This user will be an admin role. By default it will be "matillion".

Master Password

This is a required field to provide Redshift Password. Must contain one upper and one lower case letter and one digit but not quotes, slashes, @ or spaces.

Database Name

Initial Redshift Database Name. More databases can be created later. By default its matillion.

Port

Port number on which the database accepts connections. By default it is "5438".

Redshift Configurations

Redshift Configurations

If you are performing this as part of an initial AWS Stack creation, please refer back to the Launching Matillion ETL using CloudFormation Template documentation for further information.