Use Case:

User wants to create a data feed from of an objects device history to RDS so they can connect the data to either legacy systems or perhaps a BI Tool


Create RDS Tables for Each Data Type

Create lambda function with name “history-to-rds-create-tables” and upload the attached Zip file: history-to-rds-create-tables. If using Foundry V3 use the zip files with V3 at the front.


  2. Set lambda timeout 5 min and Environment variables of created lambda:
    ENV: prod
    DB_HOST: copy DB_HOST variable from fndy-utility-advanced-search-secure-prod lambda


  3. Create new test event with empty JSON and run Test



  4. Lambda will get existed device types from DynamoDB and create tables in RDS with names “_history_type_{typeId}”

Install History Trigger

Create new lambda with name “trigger-history-to-rds” and upload attached zip: trigger-history-to-rds.zip


  2. Set lambda timeout 5 min and Environment variables of created lambda:
    DB_HOST: copy DB_HOST from Step 1.2

  3. Add DynamoDB trigger on “fndy_object_info_prod” table