AWS Redshift

Amazon Redshift is a data warehouse product and part of the larger cloud-computing platform Amazon Web Services. It is built on top of ParAccel, the massive parallel processing (MPP) data warehouse, to handle large-scale data sets and database migrations.

Here’s how to export the data in a View in Mammoth to the AWS Redshift on a remote server:

  1. Open Data Preparation > Exports > AWS Redshift;

  2. Enter your database credentials - Host, Username, Password, Database and the Table name;

  3. Tick the checkbox “Keep at the end of the pipeline” to keep the export task at the end of your pipeline. Any task performed will be added to the Pipeline before the export task;

  4. Tick the checkbox “include hidden columns” if you want the hidden columns to be exported;

  5. Validate the credentials;

  6. Once it is validated, click on Apply.

    AWS Redshift credentials

A table with data from the View will be created in the remote database.