2 Answers
- Newest
- Most votes
- Most comments
1
To answer your question, we require details that are non-public information. Please open a support case with AWS using the following Link.[https://console.aws.amazon.com/support/home#/case/create]
0
The problem was we were using the default SQL engine version (2015-10-08), which doesn't support nested object queries.
After updating our topic rule definition to use a newer version (2016-03-23), it started working as expected.
# Topic rule
Test1TopicRule:
Type: AWS::IoT::TopicRule
Properties:
RuleName: !Ref Test1TopicRuleName
TopicRulePayload:
AwsIotSqlVersion: '2016-03-23'
Sql: SELECT *, topic() as topic FROM '/test1/#'
Actions:
- Lambda:
FunctionArn: !GetAtt Test1Lambda.Arn
Description: 'A topic rule'
RuleDisabled: false
answered 2 years ago
Relevant content
asked 3 years ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated 3 months ago

I just opened a support ticket. Thanks