How to schedule export/import data to DynamoDB

Import/Export scheduler allows scheduling of import/export DynamoDB data from/to a csv file.

When you schedule import, the csv file has to be in S3 bucket.

When you schedule export, the csv file is saved to S3 bucket.

To schedule import or export of DynamoDB data from the Main Menu, select DynamoDB.

From the context menu, select Scheduler.

Within the scheduler windows, make the following configurations:

Action – Select either import or export data

Scheduler – Select when the action should be executed

S3 Bucket – Select S3 Bucket when the csv file is outputted. If you are scheduling import, after selecting S3 Bucket the list of files in the bucket is visible.

Check the file that contains data you want to import and click Continue. If the first row of import data contains column names, check the First row includes columns header checkbox. If you selected the wrong S3 Bucket, click Back to select a different bucket.

The next step after selecting the file is to map data between import file and DynamoDB. The new window lists all DynamoDB columns on the left and drop down lists with listed name of columns from the import file on the right. To map data from the the drop down list, select the name of the column. If you do not want to map the given column, select Don’t Map from the drop down list. When you finish mapping, click Continue.

Note: if the import file does not have the name of the columns in the first row, the drop down list shows Column1, Column2, etc. – the number represents the column number in your import file.

Also, keep in mind multiple files are selected to import, all of those files must have the same mapping.

Click Map button to change mapping at any time.

Import Action – This option allows selection of import data to append to the existing data: select Append Data, or Overwrite Data to select existing data to delete prior to import of the new data

Click Save to complete configuration.

At any time you can edit, suspend, or delete scheduler by clicking the appropriate action from the scheduler's list.