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...
Topics
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
Relevant questions
Best way for a Wireless IoT Lambda decoder to determine decoder type?
Accepted Answerasked 6 months agoIoT Rule SQL error for reserved topic
asked a month agoLoRa & Basic Ingest
Accepted Answerasked a month agoCant trigger a rule for a job execution update (UpdateJobExecution)
asked 3 years agoHow to post a DeviceEUI to a IoT topic?
Accepted Answerasked 6 months agoAWS IoT DynamoDB rule not able to read value SELECTed from topic() function
Accepted Answerasked 2 years agoAWS IoT Rule to send MQTT message to DynamoDB not working
Accepted Answerasked 2 months agoAWS IoT Core Rule Action to Timestream DB
asked 2 years agoCan't create a topic rule that includes a lambda action
asked 3 years agoBoto3 Lambda - Existing custom IoT Rule as event source
asked 4 months ago