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
MQTT messages from Python not being published to AWS IoT Core / Amazon Timestream
I am working to send messages from an Arduino board (connected to DHT11 sensor and IR breakbeam) to AWS IoT Core. It seems that messages are being published, but the messages are not showing up in my AWS account. I have a rule set up that will send…
jacobtprice
- 1
- 1
0
votes
0 answers
Storing numeric values as varchar in Timestream
I am aiming for cost-efficiency in my data handling practices with Timestream, so I have been trying to decide how best to store numeric values that have a range on the lower side (less than 8 digits).
If I have understood the documentation correct,…
Aidan T
- 1
0
votes
1 answer
AWS IoT Core rule sql for dynamic MQTT key/values
I want to use AWS IoT Core as a MQTT broker and write them to an Amazon Timestream database using IoT rules.
The MQTT messages come from different sensors and therefore there are different keys in the messages.
For example I have
{
"points": {
…
r2rp4l
- 21
- 2
0
votes
0 answers
How to do a proper data modeling for AWS timestream?
I have smart meter data for approximately 6,000,000 meter series. For each meter, we have data for three different schemes: log, daily, and 30min. Should I create three separate tables for these schemes? Our current goal is to identify anomalous…
Yiffany
- 262
- 2
- 10
0
votes
0 answers
AWS timestream with nested json structure
We are going to move our time series data into timestream, but I can not find any information about how to do that, our IOT data come to s3 as a million small files(JSON) on a daily basis, and each JSON looks like this:
{'meter_id':'123',…
Yiffany
- 262
- 2
- 10
0
votes
1 answer
Application (audit) logging using AWS - Timestream vs DynamoDB
We have a large CMS application that produces quite a large amount of log data (upto 100,000 records per day). We want to be able to store the audit log (something like this) -
timestamp, entity type, entity ID, operation ,
pbs
- 3
- 1
0
votes
0 answers
AWS IoT Timestream Role doesn't save messages
few weeks ago I have implemented an AWS IoT Rule which writes all received values into a timestream table.
SELECT uplink_message.decoded_payload.temperature AS temperature, FROM 'lorawan/+/uplink' WHERE end_device_ids.application_ids.application_id…
Robert
- 1
- 1
0
votes
1 answer
AWS IoT-Core Rules Query SELECT Data from MQTT Message (JSON) doubled nested objects Failure
I've been trying to import data from an MQTT message into AWS's Timestream database via a rule for some time. I always get the error
"errorMessage": "Failed to write records to Timestream. The error received was 'Errors at dimensions.1: [Errors at…
NLVP
- 1
0
votes
1 answer
Cannot print full RejectedRecords
I try to write records into my timestream database.
My problem is that i get an Cannot read httpResponse of undefined even if i did the same thing as they describe in their guide:…
bill.gates
- 14,145
- 3
- 19
- 47
0
votes
1 answer
How to make a query statement with AWS timestream for pagination?
I used limit and offset for pagenation but it seems that offset is not available here.
SELECT *
FROM TEST_DB
LIMIT 10 OFFSET 0
I want to get some aws pages or hints for implementing pagenation here.
I looked up the aws page and couldn't get a…
sr kang
- 1
- 1
0
votes
0 answers
Timestream Automatically refresh
I am creating an application which takes values from an IOT device and then sends the values into IOT core AWS and then from AWS the data is sent to Timestream and from timestream the data is sent to Grafana DB, the problem I am facing is that for…
0
votes
0 answers
TimeStream + Grafana: Query to verify if the value of column is populated each minute
I need someone's help in determining a timeseries query on the basis of Timestream DB datasource in Grafana and set up the alert if the timestamp doesn't occur for a device in a duration of 10mins.
My initial data looks like below:
SELECT * FROM…
Jyoti Singh
- 33
- 5
0
votes
0 answers
How can I optimize AWS Timestream queries to reduce costs?
I am using AWS Timestream to ingest data and also query data. Everything is working great. However, the AWS bill is strange. Right now most of the monthly bill ($251/$253) is from the queries.
Here's what AWS Cost Explorer shows:
price per GB…
0
votes
0 answers
Dynamically I need to do binning based on Total capacity, In AWS TimestreamDB- query editor
Here is the SQL code :
WITH total_site_capacity AS (
SELECT DISTINCT(split(SiteName, '-')) AS sitename, SiteName, ProjectName
FROM "telemetrydb"."30LogIntervalTelemetry"
WHERE time >= (bin(current_timestamp,1day)-7d)-4h AND SiteName LIKE…
0
votes
0 answers
Draw a trend line with canvas in TypeScript
So i have made a code that is trying to draw a Trend Line from importeted data from AWS TimeStream.
`interface DataPoint {
x: number;
y: number;
}
const data: DataPoint[] = [
{ x: 1, y: 2 },
{ x: 2, y: 4 },
{ x: 3, y: 6 },
{ x: 4, y: 8…
ShopEySwing
- 35
- 4