I am trying to create an IoT
rule for inserting the data in the Timestream
table and I configured my query as the below:
SELECT ax-lt-011 AS first_column, ax-lt-021 AS second_column FROM "iot/topic"
but it gives the below error:
I also tried this query:
SELECT ax-lt-011, ax-lt-021 FROM "iot/topic"
But it also gives the same error. So, is it because of my column names having "-"
in between? I can’t change the source data.