Shoveling data to Redshift with pipes and filters
Let’s say you have a datasource with multiple tables with a few Million rows each. A typical architecture will probably include some kind of an Analytics warehouse. For instance, AWS Redshift is a pretty good implementation and understands the PSQL dialect.
To keep the analytics data fresh, we need some way of shoveling data into that DB. In this scenario, we used Mysql
as the OLTP-style, main application Datasource and Redshift
as the analytics cluster.