SELECT cast(state.reported.counters.value.counter1 as DECIMAL) as counter1, 
cast(state.reported.counters.value.counter2 as DECIMAL) as counter2, 
cast(state.reported.counters.value.counter3 as DECIMAL) as counter3, 
cast(state.reported.counters.value.counter4 as DECIMAL) as counter4, 
cast(state.reported.counters.units as STRING) as units, 
cast(state.reported.location as STRING) as location
cast((state.reported.timestamp) as STRING ) as timestamp 
FROM '$aws/things/WebHMI_Dnipro_1/shadow/update'