aws iot sql like

Question

SELECT 
  clientId() as clientId,
  CASE clientId()
    WHEN 'bus_#' THEN 'bus'
    WHEN 'car_#' THEN 'car'
    ELSE 'noThingType'
  END as thingType
FROM '$aws/events/#'

clientId : bus_001, bus_002, car_aaa, car_bbb

You can search the connection history through AWS IoT SQL: FROM '$aws/events/#'. The clientId is fixed in the front and variable in the back.
I want to look up thingType by looking at clientId. Is there an AWS IoT SQL that behaves like MySQL?
please answer about my question. Thanks in advance.

Answer

Hi. The [startswith()]( https://docs.aws.amazon.com/iot/latest/developerguide/iot-sql-functions.html#iot-func-startswith) or [substring()](https://docs.aws.amazon.com/iot/latest/developerguide/iot-sql-functions.html#iot-func-substring) functions may be of interest.

Alternatively you might consider to use a Lambda to process the events, particularly if you've used [registry thing types](https://docs.aws.amazon.com/iot/latest/developerguide/thing-types.html).

aws iot sql like

Contenido relevante