You work for an organization that stores purchase order details, such as customer ID, item codes, and item quantity in an on-premise MySQL database. You need to analyze purchase order details to know the items ordered in a particular state and move data from the on-premise MySQL database to state-wise target tables in an affordable cloud-based environment.
Use Amazon Redshift V2 Connector to create a parameterized mapping to state-wise read purchase records from the MySQL database and write them to multiple Amazon Redshift targets to prepare an upcoming marketing campaign for all states.