can't push data from AWS IoT Core to AWS TimeStream

Question

i finished 2 days trying to search and solve my problem but no result, i wish i can get some help from you. i am pushing data from local pc running KEPServerEX to AWS IoT Core using MQTT Agent. i can see the data updating on AWS without issue. Then i created a DB and table on TimeStream called respectively Kep_DB & Table_Kep1. my issue is that i am trying to create a Rule on AWS IoT Core to send data to the DB table. a rule to work it require to create an SQL like statement and Dimensions.

below what i have tried:

`SELECT (SELECT v FROM values) as value FROM 'iotgateway'`

Then as dimension i put 1 dimension like below:

name: id value: ${id}

my pyload on AWS IoT Core is having this format:

`{
  "timestamp": 1668852877344,
  "values": [
    {
      "id": "Simulation Examples.Functions.Random1",
      "v": 7,
      "q": true,
      "t": 1668852868880
    },
    {
      "id": "Simulation Examples.Functions.Ramp2",
      "v": 161,
      "q": true,
      "t": 1668852868880
    },
    {
      "id": "Simulation Examples.Functions.Sine4",
      "v": 39.9302559,
      "q": true,
      "t": 1668852868880
    }
]}`

I am still not able to see to data coming to my DB even i tried several dimension name and several SQL statement format.

Any experience on this please ?