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
How to select Amazon Timestream in Grafana as data source
By following this document and tutorial video at that time, when I tried to set AWS Timestream as data source in Grafana, but I could not find it.
I use free account.
Could you tell me what the problem is?
Ryo Matsuzaka
- 135
- 1
- 1
- 9
0
votes
1 answer
Reprocessing millions of S3 files via AWS Lambda
I'm struggling with a setup for a following use case. I have possibly millions of files in S3 bucket, divided into days. I want to put all of the data of a certain period to timestream for time based queries. Unfortunately, I noticed that a single…
JFCorleone
- 623
- 6
- 18
0
votes
2 answers
How to setup a Time Series chart in Grafana from a AWS Timestream - getting (Data is missing a number field)
I have the following set of data in a AWS Timestream database:
Inside Grafana I can get the data and display as a table like following:
If I select display data as time series I get the following error: Data is missing a number field
Even in the…
IgorAlves
- 5,086
- 10
- 52
- 83
0
votes
1 answer
AWS Timestream query to detect when I am not getting data
AWS Timestream uses a query language based on SQL. I have a Timestream database table that is receiving a heartbeat from senders every 4 minutes. The thought is to detect is something is down. The data looks like this:
Thing measure_name time …
Eric Snyder
- 1,816
- 3
- 22
- 46
0
votes
1 answer
SQL return nothing if it not exist
I have the following query:
select
max(case when measure_name = 'consumption' then measure_value::double end)
consumption,
max(case when measure_name = 'generation' then measure_value::double end)
generation,
max(case when measure_name =…
bill.gates
- 14,145
- 3
- 19
- 47
0
votes
2 answers
SQL group data into an array
I have this query which works:
select point_delivery_number, year(time - -120m) as year, month(time - -120m) - 1 as month, SUM(consumption) as value from "energy_datapoints"."formatted_raw"
WHERE point_delivery_number in ('AT523452345sadf345',…
bill.gates
- 14,145
- 3
- 19
- 47
0
votes
1 answer
SQL group data to an array of objects
I have an table like this:
What i want to achive is to group it by its point_delivery_number and the other data should be grouped into an array. The result should be like this:
point_delivery_number | data…
bill.gates
- 14,145
- 3
- 19
- 47
0
votes
1 answer
How to group data with SQL
How do I group my Timestream data?
The table looks simplified like this:
point_delivery_number | measure_name | time | value
------------------------------------------------------------------------
AT3265345345 |…
bill.gates
- 14,145
- 3
- 19
- 47
0
votes
1 answer
AWS Timestream "Not equal" comparison throws error
I have a query where I want to fetch all data where "completed" field is not equal to 0, but it throws an error. I dont get it why as their documentation supports these comparisons.
$result = $query_client->query([
'MaxRows' => 1,
…
showtime
- 1
- 1
- 17
- 48
0
votes
0 answers
How to add unique ID when inserting data in AWS Timestream?
I am inserting some data in Timestream but I cant figure out how to have a unqiue ID.
$date = new DateTime();
$time = strval($date->getTimestamp() * 1000);
$dimensions = [];
$i = 0;
while ($i < 1) {
$expected_delivery = '2022-04-30…
showtime
- 1
- 1
- 17
- 48
0
votes
1 answer
How to configure AWS Timestream SDK in React Native? (Error: Cant find variable Credential)
I need to configure the RN SDK for AWS timestream but I keep getting an error:
Cant find variable Credential.
import { TimestreamQueryClient, CreateDatabaseCommand } from "@aws-sdk/client-timestream-query";
const client = new…
showtime
- 1
- 1
- 17
- 48
0
votes
1 answer
How do i reference an existing timestream table in CDK?
I am using AWS CDK (Python) to manage infrastructure, including Amazon Timestream databases and tables.
Suppose i have an existing Timestream table that i want to set permissions on using CDK.
The only way i have seen to get a hold of a Timestream…
Joel Ödlund
- 15
- 4
0
votes
1 answer
AWS Timestream query to get average measure for the first month of samples
In AWS Timestream I am trying to get the average heart rate for the first month since we have received heart rate samples for a specific user and the average for the last week. I'm having trouble with the query to get the first month part. When I…
Eitan
- 1,434
- 6
- 21
- 53
0
votes
2 answers
Automatically ingest Data from S3 into Amazon Timestream?
What is the easiest way to automatically ingest csv-data from a S3 bucket into a Timestream database ?
I have a s3-bucket which continuasly is generating csv files inside a folder structure. I want to save these files inside a timestream database so…
Helwig
- 23
- 1
- 4
0
votes
2 answers
How do you handle ProgressPercentage not returning 100?
I am using the node @aws-sdk/client-timestream-query 3.53.0 package. I am running into an issue where the result of ProgressPercentage is not 100 but the promise returned.
const promise = this.client
.send(command)
.then((data) =>…
Adam
- 3,615
- 6
- 32
- 51