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
7
votes
2 answers

Can I delete records from Amazon Timestream?

Executing a delete query on an Amazon Timestream DB. When executing this query: delete from "data-api-timestream-test"."test_table" I get the error: The query syntax is invalid at line 1:1 Can I delete records from Amazon Timestream?
Adelin
  • 18,144
  • 26
  • 115
  • 175
7
votes
1 answer

Timestream - Pivot data per dimensions

TimeStream stores data with a key:value approach. Is there any simple way to pivot the data based on the dimensions to get for instance the max of all available measures in a column that is named as the measure name ? Let take an example, with…
Florck
  • 204
  • 1
  • 13
6
votes
3 answers

AWS TimeStream: Records that are older than one day are rejected

I created a database table in AWS TimeStream which has a memory retention period of 7 days: However, when I try to upload data that is 3 days old, it will be rejected. It seems that only data newer than 24 hours is…
rabejens
  • 7,594
  • 11
  • 56
  • 104
5
votes
0 answers

How to safely incorporate query parameters into AWS TimeStream queries in Python or Java?

The SQL query interface of AWS TimeStream SDKs only accepts a query string. It appears that constructing the query string, including any parameter values in where clauses and such, is left wholly to the user of the SDK, which is not the norm in…
Tuure Laurinolli
  • 4,016
  • 1
  • 22
  • 21
5
votes
2 answers

AWS Timestream: Unable to ingest records into AWS Timestream

As you all know, AWS Timestream was made generally available in the last week. Since then, I have been trying to experiment with it and understanding how it models and stores the data. I am facing an issue in ingesting records into Timestream. I…
ShwetaJ
  • 462
  • 1
  • 8
  • 32
4
votes
0 answers

Is AWS Timestream a good solution to store an audit log?

My application offers a WRITE API that writes and deletes data to DynamoDB, and we want to store an audit log of what happened, like this: timestamp, account, ADD/DELETE, information We want to be able to satisfy queries like: For account X, give…
Maria Ines Parnisari
  • 16,584
  • 9
  • 85
  • 130
4
votes
1 answer

AWS Timestream: How to select OHLC values?

I'm trying to use AWS Timestream as the datasource for a POC of a stock analytics application. I plan to save stock data at the lowest interval available in the DB and then query the desired timeframes. What I tried so far is to use window…
Sebastian Grunow
  • 104
  • 4
4
votes
0 answers

How to migrate InfluxDb to Amazon Timestream?

I have been trying to migrate my InfluxDb to Amazon Timestream. Since it is a new service, I am unable to find the exact documentation for migrating Influx to Timestream. I found that Telegraf can be used for connecting InfluxDB to Timestream, but…
l_k_p_Code
  • 41
  • 2
3
votes
2 answers

How to Speed up AWS Timestream query performance?

The AWS timestream Database is queried using grafana API and results are shown on dashboards While everything works well when we query for less data points but my queries would fail when I query too much data i.e, of 1-2 months for 100 or more…
kethan sarma
  • 41
  • 3
3
votes
0 answers

How do I implement against AWS Timestream REST API?

Does anyone have a working example where they've integrated against AWS Timestream's REST API? I'm looking at the query endpoint. Their documentation seems incomplete. It says integrating against their REST API is possible but there isn't much more…
n00b
  • 5,843
  • 11
  • 52
  • 82
3
votes
2 answers

AWS Timestream - SDK V3 Nodejs, TimestreamWriteClient.send() - TypeError: command.resolveMiddleware is not a function. How to solve this?

I have the following lambda function in NodeJs 14.x using AWS SDK V3 for a timestream insertion process: 'use strict' // https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-timestream-write/index.html const { TimestreamWriteClient…
IgorAlves
  • 5,086
  • 10
  • 52
  • 83
3
votes
0 answers

How to implement a backup for AWS Timestream table?

I am trying to figure out which is the best approach to build backups of a database or a table in Amazon timestream. In the AWS documentation page you can read this: While Amazon Timestream is multi-AZ, it does not support backups to other AWS…
Ruben Perez
  • 650
  • 1
  • 7
  • 13
3
votes
1 answer

How to use timestamp in AWS Timestream

I have a table with a time field and I am trying to select between 2 timestamps which are in the format: "2020-10-10 09:00:00.000000000" I have tried some functions listed here but without success. Edit: The data is there, as seen in the picture.…
David Bensoussan
  • 2,887
  • 2
  • 38
  • 55
3
votes
2 answers

How to convert a bigint in AWS timestream DB to timestamp?

I want to execute this query: select * FROM "data-api-timestream-test"."table_test" where time = 1637339664248 I get the error: line 1:71: '=' cannot be applied to timestamp, bigint I also tried select * FROM…
Adelin
  • 18,144
  • 26
  • 115
  • 175
3
votes
1 answer

Export AWS Timestream table to JSON/CSV

I need to export/dump an AWS Timestream table to CSV/JSON but I'm having trouble figuring out how to do it. Everything I find seems related to ingesting into Timestream. I was thinking about AWS Kinesis and but I can't find any existing producers…
lobbin
  • 127
  • 1
  • 12
1
2 3
…
10 11