Data pipeline - Mendix to AWS Redshift

Last modified by Erik Bakker on 2024/02/21 21:54

This exercise will guide you in practising with data pipelines processing data from Mendix to AWS Redshift.
 
Should you have any questions, please contact academy@emagiz.com.

1. Prerequisites

  • Completed previous exercises and microlearnings
  • Access to an eMagiz model with Create, Deploy and Manage rights
  • Access to a Mendix project linked to the project that you have created
  • Access to AWS Redshift

2. Exercise

The assignment is complex this time and comes with a lot of requirements as this talks about a complete integration.
So only proceed with this assignment if you have access to Mendix and AWS Redshift in addition to eMagiz.

If so, the assignment is to successfully refresh an AWS materialized view that answers the question What were the total sales per event?
This assignment can be completed with the help of an associated Mendix project linked to the (Academy) project that you have created/used in the previous assignment.

3. Solution

In this short movie, you will find the workout of this exercise. Take a moment to review this one and compare it to your solution.