How can I use Data Pipeline to copy tables from one database table to another?
"I want to use AWS Data Pipeline to copy a table to a different database. For example, I want to copy an Amazon Relational Database Service (Amazon RDS) for MySQL table or Amazon RDS for PostgreSQL table to Amazon Redshift."
"I want to use AWS Data Pipeline to copy a table to a different database. For example, I want to copy an Amazon Relational Database Service (Amazon RDS) for MySQL table or Amazon RDS for PostgreSQL table to Amazon Redshift.ResolutionCopy an Amazon RDS for MySQL table to Amazon RedshiftCreate a pipeline using one of the following Data Pipeline templates:Full copy of Amazon RDS for MySQL table to Amazon RedshiftIncremental copy of an Amazon RDS for MySQL table to Amazon RedshiftFor more information about these templates, see Amazon RDS to Amazon Redshift templates.Copy an Amazon RDS for PostgreSQL table to an Amazon Redshift tableUse the PostgresqlRdsToRedshift scripts from the AWSLabs GitHub repository. Before you begin, modify the postgresqlRDS-to-Redshift-definition.json file with the following:Your databaseYour Amazon Elastic Compute Cloud (Amazon EC2) instanceThe path to your hosted shell script in Amazon Simple Storage Service (Amazon S3)Note: Be sure to modify the JSON file according to your use case.Copy an Amazon RDS for MySQL table to an Amazon RDS for PostgreSQL tableUse the MySqlRdsToPostgreSqlRds scripts from the AWSLabs GitHub repository. Before you begin, modify the mysqlRDS-psqlRDS-copy-using-shell-definition.json file with the following:Your databaseYour EC2 instanceThe path to your hosted shell script in Amazon S3Note: Be sure to modify the JSON file according to your use case.Related informationDefine a pipeline in JSON formatFollow"