Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel to handle large scale data sets and database migrations.
The data in a View in Mammoth can be exported to the AWS Redshift on a remote server.
Open Data Preparation > Exports > AWS Redshift.
Enter your database credentials - Host, Username, Password, Database, and the Table name.
Check 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.
Enable the checkbox “include hidden columns” if you want the hidden columns to be exported.
Validate the credentials. Once it is validated, click on “Apply”.
A table with data from the View will be created in the remote database.