amazon-web-services - 使用 CloudFormation 创建规则时，AWS IoT parse_time 函数不起作用

Question

为什么不parse_time当我以这种方式使用 CloudFormation 创建时，函数可以工作吗？

  IoTTopicRule:
    Type: AWS::IoT::TopicRule
    Properties:
      TopicRulePayload:
        Actions:
          - DynamoDBv2:
              ...
        RuleDisabled: false
        Sql: |
          SELECT 
            clientid() as hashKey,
            concat('weather_', parse_time("YYYY-MM-dd'T'hh:mm:ss", timestamp())) as rangeKey,           
          FROM 'topic'

当数据保存在 DynamoDB 上时，rangeKey另存为weather_我预计它会被保存为 weather_2020-05-28T07:05:57 ，例如。

Answer 1

这是因为CloudFormation使用2015-10-08版本创建SQL查询，并且该版本不支持parse_time功能:

Use the parse_time function to format a timestamp into a human-readable date/time format. Supported by SQL version 2016-03-23 and later.

将 AwsIotSqlVersion: '2016-03-23' 添加到模板即可解决该问题。

  IoTTopicRule:
    Type: AWS::IoT::TopicRule
    Properties:
      TopicRulePayload:
        Actions:
          - DynamoDBv2:
              ...
        AwsIotSqlVersion: '2016-03-23'
        RuleDisabled: false
        Sql: |
          SELECT 
            clientid() as hashKey,
            concat('weather_', parse_time("YYYY-MM-dd'T'hh:mm:ss", timestamp())) as rangeKey,           
          FROM 'topic'