Use this tag for questions about Amazon Timestream, a fully managed time series database service.
Questions tagged [amazon-timestream]
153 questions
0
votes
0 answers
can't push data from AWS IoT Core to AWS TimeStream
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…
Abdelmoula
- 1
- 1
0
votes
0 answers
How do I graph of change from previous value in grafana amazon-timestream?
My current query is
SELECT bin(time, 5m) AS bin, sum(measure_value::double) as bytesdropped FROM $__database.$__table
where measure_name='messurename' and $__timeFilter
group by bin(time, 5m) order by bin
unfortunately, the bytesdropped value is…
AC.
- 1,005
- 2
- 12
- 20
0
votes
1 answer
How to combine several non-related SQL statements into one result?
My use case is to build a dashboard from different SQL queries, but the problem is that i have let's say 50 widgets (50 different select statements) that can omit totally different results (either one value, or several rows, etc..)
As my DB is…
ArielB
- 1,184
- 2
- 11
- 36
0
votes
2 answers
AccessDeniedException for the action that is allowed to a role by a policy on AWS timestream
I'm trying to read timestream data from web app for public use.
I followed this tutorial from AWS to allow any user to see the data on web browser.
After that, I followed this github issue since discovering endpoints was failing.
The problem I'm…
hiro
- 3
- 1
0
votes
0 answers
Create Query string for AWS Timestream ScheduledQuery using Python CDK
I created the database and table like this:
# Amazon Timestream
self.database = timestream.CfnDatabase(scope=self, id="MyDatabase")
self.table = timestream.CfnTable(
scope=self,
id="MyTable",
database_name=self.database.ref,
…
Kai
- 67
- 2
- 10
0
votes
0 answers
Collating Average Data over a Time Interval for X Days/Weeks/Etc
I've got an example table that holds data with a date and a value.
Date
Value
1/1/22
3
1/2/22
5
2/5/22
6
What I want is to allow users to select a time interval for the average and a time interval for the returned data. So something…
wyt
- 83
- 7
0
votes
1 answer
Lambda function triggered by kinesis stream ingest data to Timestream
Here's my lambda function:
const AWS = require('aws-sdk');
//const dynamo = new AWS.DynamoDB.DocumentClient();
//const events ="events"
exports.handler = function(event, context) {
event.Records.forEach(function(record) {
…
fneron
- 1,057
- 3
- 15
- 39
0
votes
1 answer
How do I samples my data using Amazon Timestream
I'm working on a project where I need to get samples of hourly data using timestream. I've been using this query:
select *
FROM table_name
WHERE time >= from_iso8601_timestamp('2022-10-11T11:31:51')
and time <=…
0
votes
0 answers
Does AWS Timestream LAST_VALUE support ignore nulls arguments?
I'm trying to get use TimeStream to get the last non null value using last_value but so far haven't had any luck.
I've tried:
last_value(power ignore nulls) OVER (
PARTITION BY deviceId ORDER BY time asc range BETWEEN unbounded preceding AND…
ADringer
- 2,614
- 36
- 63
0
votes
1 answer
Timestream client does not accept TIMESTAMP as Measure value type
I have a simple payload that I would like to write into Timestream using AWS Lambda. For some reason it gets rejected with the following error if I try to add a TIMESTAMP type measure value:
ERROR RejectedRecords: ValidationException: Invalid…
Levon Shirakyan
- 188
- 2
- 11
0
votes
0 answers
Error in Nodejs SDk creating timestream datbase/tales
I have permissions, and can create Databases/Tables in the console just fine. but when i make code using the aws-sdk it fails with an InternalServerException: Internal Server Error. Is this only supported in the v3 api?
const params = {
…
Dave
- 867
- 6
- 11
0
votes
1 answer
Amazon Timestream - can I select an array element from a measure_value
I have a measure_value::varchar that is say [32603072,20213608,1314736] and named memory.
How would I select the 1st element of that array only ?
avrono
- 1,648
- 3
- 19
- 40
0
votes
1 answer
Create Amazon Timestream database without physical name using AWS CDK v2
AWS has best practices for CDK in place, which state that it's better to use generated names for resources instead of physical ones, see section "Use generated resource names, not physical names".
Consider the following Construct:
from aws_cdk…
nluckn
- 171
- 1
- 1
- 16
0
votes
1 answer
How to get a list of measure names in AWS timestream?
I want to get the list of measures in a timestream table, ie. the result of this query:
SELECT DISTINCT measure_name FROM .
The problem with this query is that it scans the entire db, which is expensive.
I wonder if there's a…
Heiner Tholen
- 3
- 2
0
votes
1 answer
How to select specific time range in AWS Timestream
In Grafana, I use AWS Timestream as data source. And I want to show only specific time range such as 9:00 to 21:00. AWS Timestream supports SQL so I write like this.
SELECT *
FROM testDB.testTable
WHERE measure_name = 'test'
AND time BETWEEN…
Ryo Matsuzaka
- 135
- 1
- 1
- 9