I get an error when using the startswith function in the WHERE clause in AWS IoT Rule SQL
I want to capture connect/disconnect events in AWS IoT Core and trigger a Lambda function based on the connection status. However, there are occasional connections with a clientId that starts with “iotconsole” that I want to exclude in the rule.