Redshift Configuration for Matillion ETL
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".
Number of Redshift Nodes created in this new cluster, that should be 1.
dc=Dense Compute, ds=Dense Storage. All nodes in the cluster will be the same type. You can select from the dropdown.
Initial Redshift Username. This user will be an admin role. By default it will be "matillion".
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.
Initial Redshift Database Name. More databases can be created later. By default its matillion.
Port number on which the database accepts connections. By default it is "5438".
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.