AWS IoT: Storing IoT data into DynamoDB Database

[@fatemehtaei]

One of the best explanations. Thank you

[@shreyaprakasan3891]

Very helpful explanation :) Thank you so much!!

[@vvnnable]

Thanks a lot Vipin, this is really helpful

[@ferinefrancis2494]

Excellent session, very effective

[@101appsCoZa]

Nice tutorial. very helpful. thanks!

[@6string34639]

Rather than manually formatting the strings in your MQTT messages, consider importing json into your project, and using json.loads() and json.dumps() to format.

[@Vipinkmenon]

Thank u for the suggestion

[@pb-dk2sy]

Can you share in detail about pricing of LAMBDA,DYNAMODB,SNS,IOT CORE....What action you have to do specially for IOT core to not exceed free tier limit?

[@TousiqWiqarTH3xTr3MiST]

sir what to do if we have multiples numbers or strings coming from IoT device. how can i add all the data into separate columns. i see you are using sort key as well @ 18:00 which adds only one more column into dynamodb i want to add 7 to 8 columns. when i add the manually it gives the following error
"One or more parameter values are not valid. The AttributeValue for a key attribute cannot contain an empty string value. Key: Ax (Service: AmazonDynamoDBv2; Status Code: 400; Error Code: ValidationException; Request ID: I7F6VQK7AU0AGFFRJMIKAH83V7VV4KQNSO5AEMVJF66Q9ASUAAJG)
"

[@Vipinkmenon]

One way is to do it using AWS Lambda. Watch this and subsequent videos (ruclips.net/video/2pg3tyPvcag/видео.html). Another way is to use AWS SDK or CLI to direct send it from your endpoint to the database. That I will explain later.

[@smart_guy8861]

@@Vipinkmenon (ruclips.net/video/2pg3tyPvcag/видео.html) this video isn't availiable. I am having multiple multiple lines in my JSON Payload. how to do that. I am seeing in the table items one by one, the items aren't stored I am just seeing one item at a time.
Kindly Help.

[@andersonjhones2345]

Hello my friend, when I disconnect a device from aws iot core the service is still waiting for connection and if yes, is it charged for it? Can you tell?
I created an item, sent it a message, but then disconnected from the brocker. Will I have any charges with the item created in aws iot core, is it waiting for connection?

[@nishant4001]

Hi, Sir Nice explanation,
just small doubt we can send sensor data directly to dynamodb then why we are using MQTT to send the data on iot core and route it to dynamodb

[@Vipinkmenon]

That is just to show available actions in iot core. I will show you later how it is actually done. IoT to lambda for processing then to dynamodb

[@nishant4001]

Thanks for the quick response sir

[@nishant4001]

Hope to have more tutorial in future

[@sivakrishnayaganti2141]

@@Vipinkmenon can u please put the video link here. I didn't find that in ur playlist.

[@farindn]

Hi Vipin, very nice explanation. I'm interested in your statement if I want to store more than 1 item, what should I do in DynamoDB? I have many items with multiple values.

[@robertalvaradolugo3010]

You can add more attributes into your payload like this: {"timestamp":"2022-02-23 06:20", "column1":"value1","column2":"value1"}

[@RuwanIndikaPrasanna]

cheers !!!

[@haroonmalik7095]

I am confused about Topic name can you help me

[@haroonmalik7095]

Is topic name is same as thing name?

[@Vipinkmenon]

Topic name can be anything. it need not be thing's name. Just any string but better to give some sensible name

[@Roxane_pgd]

if you have problems with a "_" in a partition Key, you just have to put the name of your key in this format : ${name_of_the_key}