By using AWS re:Post, you agree to the Terms of Use
/IoT Rule SQL error for reserved topic/

IoT Rule SQL error for reserved topic

0

I'm happy to see that AWS added the connection status of devices & LoRa gateways.
I was excited to use a rule to process those messages downstream, but can't figure out how.

The connect/disconnect events are published here: $aws/iotwireless/events/connection_status/+/lorawan/wireless_gateways

But when making the rule the following query: SELECT * FROM $aws/iotwireless/events/connection_status/+/lorawan/wireless_gateways

Throws an error:

SqlParseException
Unexpected character '$' $aws/iotwireless/events/connection_status/+/lorawan/wireless_gateways --------------^ at 1:15

Please tell me that this is possible and I'm just not understanding...

asked a month ago10 views
1 Answers
0

Whoops, my mistake. Looks like I had a simple formatting issue. Forgot the quotes... Should have been.

SELECT * 
FROM '$aws/iotwireless/events/connection_status/+/lorawan/wireless_gateways'
answered a month 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