Stack Overflow
Stack Overflow

Questions tagged [amazon-timestream]

Use this tag for questions about Amazon Timestream, a fully managed time series database service.

153 questions
1
vote
1 answer

In SQL language (AWS timestream) - how to get the latest value of non-grouped by column? (latest - meaning the most recent row)

My goal - is to group my data by a specific field, and select also the latest value from another field on that group. I have the following table: | type | count | action | time | a 5 put 2021-04-21…
ArielB
  • 1,184
  • 2
  • 11
  • 36
1
vote
1 answer

AWS Timestream / Grafana Querying

I'm developing an AWS timestream/Grafana dashboard, but I have some problems. I created the database and table in timestream and then in grafana I connected to the timestream datasource. Now I want to do a dashboard with queries or transformations…
jackie
  • 39
  • 5
1
vote
1 answer

AWS Timestream With Node.JS

I am currently working on a project that utilizes an amazon timestream database. I am attempting to pull the information from the database using node to populate a dashboard, but I have no clue how to link the database to the node script. I have the…
Seth Lanzel
  • 11
  • 2
1
vote
0 answers

Querying multiple time zones in Amazon Timestream

I have an application that stores telematics from vehicles across the USA. The USA has multiple time zones and the vehicle can be active and move across time zones whilst active. I want to be able to query 'yesterday' and calculate all the 'active…
Carl Thomas
  • 3,605
  • 6
  • 38
  • 50
1
vote
1 answer

aws Timestream: get empty intervals

I want to use aws timestream to track user requests to our API. In a first step I just store the user id for each request to the API. For a chart I want to get number of requests by user in certain time intervals. This SQL gets requests from user 2…
Fabian_Z071
  • 275
  • 1
  • 11
1
vote
2 answers

Sample insert into statement aws timestream DB

Is there any sample insert into statement available to insert data to aws timestream tables. I am getting invalid syntax error. Also aws documentation only provides samples with programming languages (Java,GO,Node,python) not SQL
Anil Chandran
  • 11
  • 5
1
vote
2 answers

AWS Timestream DB - AWS IOT

I am building out a simple sensor which sends out 5 telemetry data to AWS IoT Core. I am confused between AWS Timestream DB and Elastic Search to store this telemetries. For now I am experimenting with Timestream and wanted to know is this the…
KPCoders
  • 13
  • 4
1
vote
1 answer

Multi-Tenancy with AWS Timestream and Appsync

We plan a multi tenant application using the AWS Timestream database. Unfortunately the database does not support any resource-based policy. To get the isolation we need to somehow proxy the query through a Lambda Function where we can control the…
pfried
  • 5,000
  • 2
  • 38
  • 71
1
vote
2 answers

AWS timestream: How to Group by day in particular timezone

Using date_trunc or bin we can round to hour and then use groupBy, but I am not able to give a timezone option for this. Any workaround?
Riddhesh Ganatra
  • 11
  • 3
1
vote
2 answers

Write null measure values to AWS Timestream

When I try to write a record (that has missing/null measure value) in AWS Timestream, it throws the following error. Any suggestion how to ingest NULL measure values into AWS Timestream? Error: ValidationException: An error occurred…
adds
  • 11
  • 1
  • 2
1
vote
2 answers

Sum of last_value of each partition in SQL with window functions

I have a table that stores total disk used at any point in time for each entity. I want to find the peak disk used in a time period. For example, the data looks something like Note: The timestamp is actual timestamp with seconds precision, I set it…
JackDaniels
  • 985
  • 9
  • 26
1
vote
2 answers

Data not getting inserted into Timestream table when timestamp is passed via IoT core rule (via SQL time_to_epoch)

Assuming sensor sends data like this: {"timestamp": "2020-11-11 08:27:19", "temperature": 90, "device": "device1"} Create an IoT core rule to send data to Timestream db table. Rule SQL: SELECT device, temperature,…
variable
  • 8,262
  • 9
  • 95
  • 215
0
votes
1 answer

Adding a partitionKey to a Timestream table (or, create a resource that doesn't exist)

tl;dr how can I add a partition key to a table in the CDK without destroying the entire stack? I have a Timestream table which I created via the CDK, before AWS introduced support for customer defined partition keys. new timestream.CfnTable(this,…
Jake
  • 321
  • 3
  • 12
0
votes
0 answers

AWS IoT and TimeStream. how can I verify the a message was received

I would like to send data from a mobile phone to AWS IoT Core and from there to TimeStream but I must know that the data is 100% there, even in the case of Internet disconnections. As a precaution, I thought of maintaining a local database on the…
user829174
  • 6,132
  • 24
  • 75
  • 125
0
votes
0 answers

How to deploy a scheduled query on an empty table using CloudFormation?

We are using AWS SAM to deploy our stack to AWS Cloudformation. In our deployment, we create a database and create 4 tables for the database. We also create a scheduled query to periodically perform aggregations on one of the tables. However,…
Ben Flock
  • 1
1 2 3
…
10 11