You work for an e-commerce organization that stores sales order details in a MySQL database. Your organization needs to move the data from the MySQL database to an Amazon Redshift target.
task to write to Amazon Redshift.
You perform the following
task to use the insert operation.
Use a MySQL source object.
The source for the mapping is a MySQL connection that contains the sales order details. The MySQL object is a single source in the
task. You can include the Customer ID, Item_codes, Item_quantity, and Price columns. Specify
as the resource for the source object.
Create an Amazon Redshift target object.
Select the fields
from the source object that you want to insert into the target object. Provide a name
for the target object and specify the connection type as MySQL. The
task writes the data to Amazon Redshift. You can also use an existing target object.
Configure a field mapping.
Map all the fields under
source data to all the fields in the target
application writes the mapped source data to Amazon Redshift.
Configure the advanced target properties.
In the advanced target properties, you choose properties that are specific to Amazon Redshift. Specify an Amazon S3 bucket name for the Amazon Redshift target data. Use an S3 bucket in the same region as your Amazon Redshift cluster. You can also specify options for the copy command, and turn on server side and client side encryption.
Open Amazon Redshift to visualize the exported data.