Non-hub: List of Redshift Launch Templates
    • Dark
      Light

    Non-hub: List of Redshift Launch Templates

    • Dark
      Light

    Article Summary

    Warning

    New customers must go through the Matillion Hub to select their preferred cloud Provider and data warehouse to begin their Matillion ETL journey.

    Overview

    A list of the different available templates (see AWS CloudFormation) is given below. There are two main types of template: one for those who have pre-existing resources (such as Redshift clusters) and one for those who don't (new resources).

    For a step-by-step guide on how to launch a Matillion ETL instance using these templates, read Non-hub Existing Customers - Launching Matillion ETL for Snowflake using CloudFormation Templates. To migrate an existing instance to a different server, (for example, migrating from a single node to a highly available cluster), consider using the Server Migration Tool.

    If you experience problems launching via templates, please contact Matillion support, citing the template you wish to use, for help and support.

    Note

    CloudFormation Clustered templates require an external domain that's, by definition, in another VPC (or on-premises), and will likely require VPC Peering to work.


    New resources

    Templates for those who need the entire lot, brand new setup. Redshift cluster included.

    Single Node

    A single, isolated, batteries-included Matillion ETL instance, and includes:

    • m5.large|m5.xlarge EC2 instance running Matillion ETL.
    • IAM Role (attached to EC2 instance).
    • VPC and public/private subnets.
    • Redshift cluster.

    Downloads:

    Single Node & RDS

    A single, isolated, batteries-included Matillion ETL instance, and includes:

    • m5.large|m5.xlarge EC2 instance running Matillion ETL.
    • IAM Role (attached to EC2 instance).
    • Postgres RDS instance with Multi-AZ failover.
    • Cloudwatch-based logging.
    • VPC and public/private subnets.
    • Redshift cluster.

    Downloads:

    Clustered

    A clustered, isolated, batteries-included Matillion ETL instance, and includes:

    • 2x m5.large|m5.xlarge EC2 instances running Matillion ETL in a cluster.
    • IAM Role (attached to EC2 instance).
    • Postgres RDS instance with Multi-AZ failover.
    • ALB (Application Load Balancer).
    • Cloudwatch-based logging.
    • VPC and public/private subnets.
    • Redshift cluster.

    Downloads:


    Existing resources

    Templates for those who have a Redshift cluster already and want to launch a Matillion ETL instance to use with it.

    Single Node

    A single Matillion ETL instance for an existing AWS account, and includes:

    • m5.large|m5.xlarge EC2 instance running Matillion ETL.
    • IAM Role (attached to EC2 instance).

    The following resources must already exist in your AWS account, and will be referenced:

    • Redshift cluster.

    Downloads:

    Single Node & RDS

    A single, isolated, batteries-included Matillion ETL instance, and includes:

    • m5.large|m5.xlarge EC2 instance running Matillion ETL.
    • IAM Role (attached to EC2 instance).
    • Postgres RDS instance with Multi-AZ failover.
    • Cloudwatch-based logging.

    The following resources must already exist in your AWS account, and will be referenced:

    • VPC and public/private subnets.
    • Redshift cluster.

    Downloads:

    Clustered

    A clustered, isolated, batteries-included Matillion ETL instance, and includes:

    • 2x m5.large|m5.xlarge EC2 instances running Matillion ETL in a cluster.
    • IAM Role (attached to EC2 instance).
    • Postgres RDS instance with Multi-AZ failover.
    • ALB (Application Load Balancer).
    • Cloudwatch-based logging.

    The following resources must already exist in your AWS account, and will be referenced:

    • VPC and public/private subnets.
    • Redshift cluster.
    • LDAP or Active Directory based directory service.

    Downloads:


    Single Node diagram

    Single Node Architecture


    Single Node & RDS diagram

    Single Node & RDS Architecture


    Clustered diagram

    Clustered Architecture