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.
When we started out with Timestream we thought it would be a good choice to hold the billions of sensor data records we gather each year. The choice to use Timestream was largely based on the...
1
answers
0
votes
148
views
asked 4 months agolg...
Hello! I was reading https://docs.aws.amazon.com/timestream/latest/developerguide/data-modeling.html
I'm trying to understand why choosing the proper set of dimensions is important for query...
Accepted AnswerAmazon Timestream
1
answers
0
votes
332
views
asked 5 months agolg...
So I have two different tables in Timestream with the same config receiving data from two different sensors, one table is able to store the data with multiple 0 values whereas the second table is not...
0
answers
0
votes
69
views
asked 5 months agolg...
Hello,
I wanna write an Excel from my TimeStream's table in a cycle, it will write once a day. My idea is use Python. I saw many services such as Lambda, SDK and S3. What is the best service for this...
1
answers
0
votes
200
views
asked 5 months agolg...
Is there a way to share a timestream database for an IoT Thing within an organisation/user group?
Our IoT device only allows one endpoint to be assigned to receive the data, but we want to be able to...
0
answers
0
votes
115
views
asked 6 months agolg...
I have this recurring problem. I construct a web service (lambda + api gateway) that is running some query in timestream, but that query fails because there doesn't happen to be any data in the table...
1
answers
0
votes
171
views
asked 6 months agolg...
Hi,
is there a way to download/export all the data from a timestream database table? As a .csv or something like that.
Thanks and have a great day!
1
answers
0
votes
347
views
asked 6 months agolg...
Hey there,
I'm working with a Grafana Dashboard querying Timestream Data and I am looking for a solution to do the following:
```
SELECT temperature
FROM
if(${my_variable} = '1',...
0
answers
0
votes
99
views
asked 6 months agolg...
Hi Team,
I have my data in MQTT test consol, but everytime I tried to make a rule to manage routing to Timestream, nothing was pushed in my DB on the Timstream side.
I watched a many video and did...
1
answers
0
votes
184
views
asked 6 months agolg...
I know of several workarounds, but still, it would be handy to be able to execute
```
aws timestream-write write-records --records ...
```
and specify records coming from a file. A workaround is...
1
answers
0
votes
177
views
asked 7 months agolg...
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
170
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
372
views
asked 7 months agolg...