Use this tag for questions about Amazon Timestream, a fully managed time series database service.
Questions tagged [amazon-timestream]
153 questions
0
votes
1 answer
Can I dynamically set the Timestream table in an IoT Rule?
When creating a Rule in AWS IoT that sends messages to my Timestream database, it's forcing me to choose the database and table to send to.
Currently, I have a separate table for each user's telemetry data, and these messages will come from many…
michaelpanik
- 66
- 4
0
votes
1 answer
How to make AWS IoT Rule to split agregated data before sending then to Timestream
integrating exiting IoT Rule based solution with new AWS Timestream feature I came across issue, that IoT Topic messages send are aggregated. This is not integrating well with Timestream DB, as it accepts data send as single measurements.
There is…
sraka praptaka
- 16
- 1
0
votes
1 answer
Get monthly sum/agv/max of a measurement from timestream
I am storing measurements in Timestream with the following attributes (example):
@2021-01-04 00:00:00 | DIMENSIONS | MEASURES
| domain: www.foo.com | uniq_users: 9
| layer: none …
sontags
- 3,001
- 3
- 19
- 25
0
votes
1 answer
Grafana/Timestream: how to visualize number of certain events over time
I am new to Grafana and Timestream and want to expore their suitability for my needs.
My goal is to visualize a number of certain events in the logs.
I have a field repsesenting a session id (cmcd_sid ) and some indicator - cmcd_bs:
cmcd_sid …
Agenobarb
- 143
- 2
- 10
0
votes
1 answer
AWS Timestream queries over different measurements
Due to the way data is structured in Timestream, in which each row contains a different measurement, for example, load, speed, fuel (taking the sample IOT database) it becomes not obvious how to query data for questions that take more than one…
Kevin C
- 21
- 7
0
votes
2 answers
Grafana graph jumping / flickering on refresh
I am using the latest Grafana 8.2.1 with Amazon Timestream 3.1.1 datasource plugin.
I have noticed that when I use more than one query, the graph will jump / flicker on refresh.
I have the details reported in issue 40424
Just wondering if anyone…
kaptan
- 3,060
- 5
- 34
- 46
0
votes
2 answers
Timestream + Grafana
Today's build is a Grafana Dashboard which is pulling in live data from aws timestream.
Currently, it's showing line graphs which is broken down by hour. The query we use is this:
WITH binned_query AS (
SELECT
BIN(time,1h) AS "point",
…
nickCR
- 15
- 5
0
votes
1 answer
How Do You String Manipulate Return Results from Timestream?
For a simple query such as:
SELECT measure_value::varchar FROM "mydb"."mytable" LIMIT 5
which produces:
measure_value::varchar
Travis
Paul
Jon
How can you modify the query to show:
measure_value::varchar
Hello Travis
Hello…
PressingOnAlways
- 11,948
- 6
- 32
- 59
0
votes
1 answer
Writing data to AWS timestream table using IOT - timestamp not working
I am trying to use iot core rules to define an action which will send a JSON object to a timestream table. the object looks like this:
{ "Time": 1483715700000, "TimeUnit": "MILLISECONDS", "endpointID": "ahu3", "Introduction_temperature": 15.8 }
the…
sammyF
- 11
- 4
0
votes
1 answer
How to mock AWS TimestreamWrite by jest
This project is to record data by AWS Timestream, and it works well.
However, I'm failed to mock AWS TimestreamWrite by using jest. I tried some ways but not working. Can someone help me?
My files as below:
ledger-service.js
const AWS =…
Ben
- 1
- 1
0
votes
1 answer
How do I efficiently configure AWS IoT rules to write data to a device specific Timestream database?
I want to store IoT device data in a device specific table in a Timestream database. This will allow us to give users access to their particular device data only based on a specific IAM or Cognito policy.
Data from the devices would look something…
Duncan Drennan
- 871
- 2
- 9
- 21
0
votes
3 answers
AWS timestream-write gets "An error occurred (AccessDeniedException) when calling the DescribeEndpoints operation: This operation is not allowed."
I am experimenting the AWS SDK for python to access Timestream. I tried their in house example code from the repository and I wrote my own code to create a database:
import boto3
from botocore.config import Config
client =…
dgg32
- 1,409
- 1
- 13
- 33
0
votes
1 answer
Replay events and ingest them in AWS Timestream
I can't ingest records into AWS Timestream if timestamp is out of the window of Memory Store. Thus, I can't implement functionality where I replay messages, process and ingest them if there is some issue. Are there any solutions for this?
Stephen L.
- 509
- 2
- 14
0
votes
1 answer
AWS TimeStream Python SDK: Cannot create a correct client object
Based on AWS TimeStream SDK documentation for Python, I have the following code:
import boto3
def list_databases(self):
print("Listing databases")
try:
result = self.client.list_databases(MaxResults=5)
…
Nakrule
- 511
- 8
- 24
0
votes
1 answer
How to mark particular records or ranges as deleted in Timestream
I have a stream processing application that constantly ingest the data to AWS Timestream.
I try to come up with the approach when a particular range of data is processed incorrectly, thus I need to re-ingest them again and mark the ones that are…
Stephen L.
- 509
- 2
- 14