I have a Siemens 8.3 LOGO which, when connected through Logo Web Editor to AWS, automatically generates the Topics (json files), they are called by AWS as "reserved topic" type https://docs.aws.amazon.com/iot/latest/developerguide/reserved-topics.html (which begin with the $ symbol), in my case it generates quite a few of them and they work fine but i want to store the data. Since I can't modify these json files, I can't use DynamoDB so I have to use TimeStream, when I try to use the command in sql: 'import * from $aws/things/Test2/shadow/.... i got an error (-- ----Expected a name or '*' .1:1-1} --^ at 1:3------), also i have on my json files, instead of values like temperature, pressure etc, i have this format:------- "format": "json", "payload": { "previous": { "state": { "reported": { "I..1:1-1": "00", "I..1:2-1": "00", "I..1:3-1": "00", ...etc------- so I wrote on Dimension name: I..1:1-1 and on Dimension Value this one: ${I..1:1-1}. But it doesn't work for me. any ideas? Thank you so much!

asked 2 months ago40 views
2 Answers

Hi Jotapota. I'm not familiar with Siemens Logo, but I think this workshop should help you a lot: https://catalog.us-east-1.prod.workshops.aws/workshops/d998b723-97ce-4305-bbc6-e325d50fef5f/en-US

when I try to use the command in sql: 'import * from $aws/things/Test2/shadow/.... i got an error

I am very unclear on what you're doing here, but it doesn't seem right to me. Use of Timestream with Siemens Logo is covered in this section of the workshop: https://catalog.us-east-1.prod.workshops.aws/workshops/d998b723-97ce-4305-bbc6-e325d50fef5f/en-US/3-visualizingrealtimedatausinggrafana

profile picture
answered 2 months ago

I didn't even know the existence of this Siemens Logo workshop, my friend, you saved my life!!! Thank you so much!!! I will try it tomorrow! :)

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions