Table of Contents

1. Challenge

   Write Application Code

   Write code utilizing the AWS SDK for the language of your choice to convert the CSV file with the field delimiter of Ԙ and quotation character of ԡ to the DynamoDB JSON format as seen below. Also include table creation for tables that share the name of the provided files without the file extension, and write the converted files to the appropriate tables.

   Data Conversion Sample

   So this:

   "ԡ12ԡԘԡGiant Sandԡ"
   

   Becomes:

   {
       'id': {
           'N': '12'
       },
       'name': {
           'S': 'Giant Sand'
       }
   },
   

   ---

   Hint: The code can be found on GitHub.

2. Challenge

   Log In to the Provided EC2 Instance and Run the Code

   1. Log in to the provided EC2 instance using the provided IP address and credentials.
   2. Write your code to a file named pinehead_data_util and configure to be able to run as a command.
   3. Run your code!
3. Challenge

   Verify the Data Migration to AWS

   1. Log in to the AWS Management Console for the lab account with the provided credentials.
   2. Navigate to DynamoDB.
   3. Verify there are three tables and the appropriate data loaded correctly.