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. Go to Exports and Share > Export to database > Already existing database > AWS Redshift;

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

  2. 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;

  3. Tick the checkbox “include hidden columns” to export the hidden columns;

  4. Validate the credentials;

  5. Once it is validated, click on Apply.

    AWS Redshift credentials

    Fig. 145 Enter AWS Redshift credentials

A table with data from the View will be created in the remote database. The export will also be recorded as a Task in the pipeline.