Use this tag for questions about Amazon Timestream, a fully managed time series database service.
Questions tagged [amazon-timestream]
153 questions
1
vote
1 answer
How should I update a field of a record in Amazon Timestream?
I am trying to update a field in a record in Timestream but it keeps inserting new record instead.
Here is my code:
$dimensions= [];
$dimensions[] = [
'Dimensions' => [
[
'DimensionValueType' => 'VARCHAR',
'Name' => 'id',
…
showtime
- 1
- 1
- 17
- 48
1
vote
0 answers
Get Sensor value from complicated MQTT message - Nested object queries
I need to get the temperature and humidity values and store them into a AWS timestream table as values, so that i can use them in Grafana.
How could i retrieve those numbers-values in a usable format instead of string array?
I tried to retrieve only…
vatech696
- 31
- 3
1
vote
1 answer
Does flyway support AWS Timestream?
Does anyone know if flyway supports migrations for AWS Timestream? I don't see Timestream in the docs as a supported database, but wanted to double check.
If not, can anyone suggest a CI/CD way to handle migrations for AWS Timestream?
Allen Brooks
- 11
- 3
1
vote
1 answer
Access Denied Error while inserting into Aws Timestream on Serverless Stack
I'm trying insert a record into my aws timestream table. And its getting resulted in a access denied error.
Here is the permission on serverless.yml
- Effect: Allow
Action:
- timestream:*
Resource:
-…
Sedhu
- 723
- 1
- 11
- 36
1
vote
1 answer
Timestream- failed to satisfy constraint: Member must satisfy the bytes range [1, 2048]
I am trying to insert a record in Timestream table where an attribute value exceeds the bytes range[1, 2048]. Is it possible to increase the range?
Anjaneya
- 11
- 4
1
vote
1 answer
Can I update the records in AWS Timestream?
Can I update the records data in AWS timestream? From what I have read, delete & update operations are not permitted in timestream. Is there any workarounds to perform the update operation on the timestream records?
Sudheesh S Babu
- 71
- 1
- 9
1
vote
1 answer
How to find out what i'm doing wrong. Getting validation exception in timestream write Records with go sdk?
As the title says, I'm trying to write a bunch of records to timestream, but I keep getting "ValidationException" without any further information, so I have no idea what should be fixed. The exact error response is:
operation error Timestream…
David Perez
- 478
- 5
- 17
1
vote
2 answers
Siemens logo Shadows and AWS IoT Timestream problem
I´m trying to separate my shadow data values from Siemens Logo device into correct columns - each value should be written to Amazon Timestream separately however they value names contains characters like dashes etc. and I´m not able to separate the…
Michal Žák
- 11
- 1
1
vote
1 answer
last() function for AWS Timestream db to return last non-null value of a column
i am currently using a AWS Timestream Database in combination with grafana. If i want to get the last non-null record of a column i am querying a timeinterval and using the limit funtions to only display the last value.
Select DevEUI, time,…
Ew Na
- 55
- 7
1
vote
3 answers
grafana multi value query in timestream
i have some problems displaying my aws timestream data in grafana. I added as a global dashboard variable DevEUI with 3 different specific values. But when i am using the multivalue syntax ${DevEUI} in my query with more then one value i get…
Ew Na
- 55
- 7
1
vote
1 answer
How to mock aws timestream for unit test on python?
I found on the net an example to test the aws timestream service; when I try to launch the test I get a NoRegionError
#test_timestream.py
import logging
from datetime import datetime
import pandas as pd
import awswrangler as wr
import logging
from…
Roberto Vizzi
- 25
- 2
1
vote
1 answer
Timestream pagination not working on nodejs
I am facing some issues while querying Timestream DB from my NodeJS environment. I am receiving an empty array in response for all the queries that have large response The exact same queries are working when I use the console. So I am sure the query…
Jai Jain
- 11
- 1
1
vote
1 answer
Unable to write to AWS Timestream Table ResourceNotFound Exception
I am trying to write to a Timestream database I have created. But, before that it should be stated that I have my AWS account set up with a DEV account and a Prod account which I role switch into.
I created the Timestream database and Table in…
KoalaKey
- 252
- 3
- 11
1
vote
2 answers
Aggregating Counts in AWS Timestream Error Causes Errors
I have telemetry being pushed to AWS timestream:
measure_value::varchar
IP
time
measure_name
test.html
192.168.1.100
2021-05-25 14:27:45
hits
blah.html
192.168.1.101
2021-05-25 14:27:45
hits
test.html
192.168.1.102
2021-05-25…
PressingOnAlways
- 11,948
- 6
- 32
- 59
1
vote
1 answer
AWS Timestream: Given correlated subquery is not supported
select host, time as currentTime, floor((1 - (
select sum(measure_value::double)
from "DendroTimestreamDB"."hostMetrics"
where cpuMode = 'idle'
and time <= h.time
group by host
) / ((
select sum(measure_value::double)
from…
Angel Bates
- 23
- 5