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
2
votes
1 answer

How to downsample data in AWS TimeStream

I understand AWS TimeStream allows data to be moved to different types of storage based on retention period but we also need data to be downsampled based on retention period. For e.g. 48 hours, one second granularity 30 days, one minute…
Jai
  • 694
  • 5
  • 15
1
vote
1 answer

How can the AWS timestream dimensions value be updated?

Currently, lets assume I have 2 dimensions (Car, Model) and the corresponding measure/value. Now, I want to add a 3rd dimension (Location) in the records that I write in future. Since the 3rd dimension (Location) is empty for the earlier records…
akash
  • 864
  • 8
  • 13
1
vote
1 answer

SQL query to change rows into columns based on the aggregation from rows

I have a table, "MyTable" as below: tool team metric date tool1 team1 25 1/1/2023 tool1 team1 10 2/1/2022 tool2 team2 20 1/2/2022 I want to aggregate "metric" periodically by years (distinct years as columns) and have the sql query…
jenny
  • 11
  • 2
1
vote
1 answer

How to populate an AWS Timestream DB?

I am trying to use AWS Timestream to store data with timesteamp (in python using boto3). The data I need to store corresponds to prices over time of different tokens. Each record has 3 field: token_address, timestamp, price. I have around 100 M…
Vince M
  • 890
  • 1
  • 9
  • 21
1
vote
1 answer

What are some patterns for sending telemetry data from Iot Core to Timestream?

I have a large number of Iot Devices that are generating data and sending it to IoT Core through MQTT. I need to store this telemetry data in a timestream table. I am trying to reduce costs as much as I can, while keeping the latency reasonably low.…
Prithivi Maruthachalam
  • 21
  • 3
1
vote
0 answers

Cannot access Timestream via PrivateLink without explicitly passing endpoint_url

I am trying to access Timestream from EC2/Lambda instances that run within a VPC so that I can speak to a RDS instance from those EC2 instances/Lambda functions. I have spent many hours trying to get access to Timestream via PrivateLink/a VPC…
AKiss
  • 11
  • 2
1
vote
0 answers

Padding out data in timestream without intepolation

I'm trying to write a query in timestream where I can get how long a device is powered on, and what mode it was in at the time. So I have two measures for this: power and operation_mode. What I have so far this the following query: with…
ADringer
  • 2,614
  • 36
  • 63
1
vote
2 answers

Prepared statements in timestream

I would like to execute a prepared statement to query my Timestream database. I've looked through the documentation and found prepare_query, however, it's very unclear to me what this actually does. It seems that all it can do is verify that the…
Jake
  • 321
  • 3
  • 12
1
vote
0 answers

Component integration test for application using AWS timestream

I have an application that connects to AWS timestream. I'm currently using python and boto3 to connect to it and do some queries. My current approach to test the queries is to actually load some test data in AWS timestream in some specific tables…
hfc
  • 614
  • 1
  • 5
  • 13
1
vote
1 answer

Send multi-measure record from AWS IOT Core rule to Amazon Timestream

I have an IOT Device sending temperature, humidity and pressure to AWS IOT Core and, with a rule, send it to an Amazon Timestream DB, using the following SQL statement in the IOT Core rule: SELECT temperature, humidity, pressure FROM…
betelgeuse
  • 430
  • 2
  • 10
  • 24
1
vote
0 answers

Are AWS endpoint overrides universal for all other AWS SDK services?

I'm working on a system that saves large amounts of data to AWS Timestream and AWS S3 from an Apache Flink pipeline. I use the AWS SDK for this. …
Normalerd
  • 43
  • 8
1
vote
0 answers

Aws timestream cost when querying only the last entry

In my scenario I have a aws timeseries table and for a specific dimension I need the most recent entry . I will still be charged a total of 10MB data scanned for this ? Is there a way to reduce or circumvent this cost ?
Cap Barracudas
  • 2,347
  • 4
  • 23
  • 54
1
vote
1 answer

Add string to query result

I have the following query: select point_delivery_number, bin(time,1h) as time , AVG(self_coverage) as self_coverage , AVG(generation) as generation , AVG(consumption) as consumption from "energy_datapoints"."formatted_group_raw" GROUP BY…
bill.gates
  • 14,145
  • 3
  • 19
  • 47
1
vote
1 answer

Allow timestream:describe execution

I am writing up a AWS lambda function that will crunch some data and add it to a AWS timestream table. I get this error: lambda-foobar is not authorized to perform: timestream:DescribeEndpoints because no identity-based policy allows the…
ndrb
  • 91
  • 2
  • 8
1
vote
1 answer

Writing record with MeasureValues error: Please use measureValue to send the data

I am writing to Timestream a list of dimensions and a list of measureValues but I keep getting this error: "Message":"measureValues (list) not supported for BOOL, DOUBLE, VARCHAR and BIGINT data types. Please use measureValue to send the…
showtime
  • 1
  • 1
  • 17
  • 48
1 2
3
…
10 11