title: Copying DynamoDB table to another DynamoDB table with transforms
body: <p>I have two DynamoDB tables: Table_1 and Table_2. I am trying to deprecate Table_1 and copy information into Table_2 from Table_1, which has different GSIs and different LSIs.</p>
  
  <p>Table_1 attributes are: Id, state, isReused, empty, normal</p>
  
  <p>Table_2 attributes are: UserId, Status, isOld, normal</p>
  
  <p>Id maps to UserId, state maps to status, normal maps to normal, empty is dropped from Table_2, and if the state is "OLD" then isOld sets to true.</p>
  
  <p>What is the best way to export this data from Table_1, do the transform on the attributes/data, and then load the information back into Table_2?</p>
  
  <p>Currently, I am able to use AWS Data Pipeline to import/export data from Table_1 to Table_2 with the given templates, but this does not do the transforms. I'm guessing that I need to use EMR to do the transforms. </p>
  
  <p>I also use DynamoDB streams to keep the table in sync, but from my understanding, DynamoDB streams only streams updated information, not information that already exists in a table. </p>