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

feita há 2 anos322 visualizações
1 Resposta
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'
respondido há 2 anos

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas