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...