Questions tagged with Amazon Timestream
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hi,
If i run the time extraction functions on the first day of the year like i.e.
```
SELECT week('2021-01-01 16:55:46.000000000')
SELECT EXTRACT(WEEK from '2023-01-01 05:55:46.000000000')
```
I get...
1
answers
0
votes
171
views
asked 7 months agolg...
Hi,
What is the easiest way of accessing data held in a Timestream table from a provisioned Redshift cluster (e.g. to run SQL queries against this table and combine this with other data stored with...
1
answers
0
votes
373
views
asked 7 months agolg...
Hi,
We are currently investigating the use of the Timestream Athena connector (https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html) as a way of enabling our data teams to work...
0
answers
0
votes
124
views
asked 7 months agolg...
Hi,
I have what I think is a pretty common use case, whereby I'd like to keep "hot" data in my Timestream table memory store for 30 days before moving this to "colder" magnetic storage for keeping...
1
answers
0
votes
282
views
asked 8 months agolg...
You can't delete records from Timestream, but sometimes mistakes get in there. For what I'm doing, it's probably the right thing to do to leave those records there, anyway. Since you can't delete...
Accepted AnswerAmazon Timestream
1
answers
0
votes
658
views
asked 8 months agolg...
In a previous question/response on here someone asked about durability of the timestream memory store, and the response was assuring but very qualitative. It would be nice to see an actual durability...
Accepted AnswerAmazon Timestream
1
answers
0
votes
211
views
asked 8 months agolg...
If I do a batch write of record into time stream in order, but only SOME of the inserts/upserts fail, will the rest of them get written and only the failed ones get put into the reject bucket?
I...
Accepted AnswerAmazon Timestream
1
answers
0
votes
191
views
asked 8 months agolg...
We have one API gateway that receive data 24x7 of gzipped meter data and the data come in concurrently(some times 5000 posts per second, sometimes not much), we are sure the compressed data won't...
1
answers
1
votes
343
views
asked 9 months agolg...
Hello Reader,
Context:
I am working on a project where i want to capture the incoming data from an external MQTT broker and visualise it inside the grafana, So i created the EC2 instance and using...
1
answers
0
votes
452
views
asked 9 months agolg...
We created a Timestream batch load job to backfill a table. The input was approximately 70 CSV files with sizes between 7MB and 15MB. The job finished successfully with indicating that 0 records were...
Accepted AnswerAmazon Timestream
2
answers
0
votes
206
views
asked 9 months agolg...
I am really puzzled by Timestream [PrepareQuery](https://docs.aws.amazon.com/timestream/latest/developerguide/API_query_PrepareQuery.html). You can make this call and it will validate it but not...
Accepted AnswerAmazon Timestream
1
answers
0
votes
384
views
asked 9 months agolg...
I'm using various SDK v3 clients in my lambda, IoT and Timestream for example, and sometimes when the lambda is updated or otherwise goes through a cold start, the endpoint discovery seems to take too...
1
answers
0
votes
192
views
asked 9 months agolg...