[10-Minute Exercise] How to load data from MySQL to Amazon Redshift

Difficulty Level: Medium

In this exercise, you will learn how to load data from MySQL to Amazon Redshift.

Watch this 3-minute video to learn how to load data to Amazon Redshift:

Step 1: Go to the Pattern Catalog and select “MySQL Redshift Loader” to use this pipeline pattern. If you don’t see it on your Pattern Catalog, upload this: MySQL Redshift Loader - 2021-02-24 21_47_19_2021_02_24.slp (3.9 KB)

Step 2: Make sure to whitelist certain IP addresses as per the Amazon Redshift Getting Started Guide. The IP Addresses are listed on the first page of the Pipeline Configuration Wizard when you open the MySQL to Amazon Redshift pattern for the first time.

Step 3: Open the MySQL-Select Snap and click on the Account tab to provide your database login information. You will need to label the account and provide your account properties, such as the MySQL hostname, port number, and database name.

Step 4: Now open the Amazon Redshift - Bulk Load Snap to add your Redshift account information in the Account tab. You will also need to label the account name and the account properties, such as the Redshift endpoint, port number, and database name. Now you are ready to load data into Redshift.

Step 5: Open up the MySQL - Select Snap. Provide the table name, the ‘where’ clause (a query of the data you need), and the order of your data. Click Save and close the dialog.

Step 6: Now open up the Redshift - Bulk Load Snap. You will need to provide the table name and set any other settings as needed. Click Save and close the dialog.

Step 7: Click on image to validate the pipeline. The pipeline is ready to be executed, you can click on f94f3438-034f-4696-b74d-c17799ffb2d3 on the toolbar. The pipeline will turn green once it’s successfully executed.

Step 8: You can view the data in your Redshift account.

Congratulations! You have completed this pipeline exercise!

Need more help?

You can launch the step-by-step exercise and additional resources on the SnapLogic Knowledge Center on our SnapLogic platform, or peruse through the categories and topics on the SnapLogic Community.

[ The SnapLogic Knowledge Center is only available within the SnapLogic Free Trial. ]