AWS IoT SiteWise is likely part of the solution, even with the 7-day limitation. SiteWise supports hot and cold data tiers. Your historical data is essentially cold tier data; most likely you should look to bulk stream it to S3 and focus only on your new data being ingested to the SiteWise hot tier.
After your data is sent to the cold tier, you can use the following AWS services to create historical reports or analyze and query your data:
- Run SQL queries on your data by using Amazon Athena.
- Perform big data analysis by using Amazon EMR.
- Search and analyze your data by using Amazon OpenSearch Service.
Needs to clean-up stale data from DynamoDB table which is older than 90 days by keeping cost as low as possibleasked 10 days ago
AWS CodeArtifact, credential profile per solutionasked a month ago
Is it possible to map the group as an attribute?asked 17 days ago
Timestream Historical Data (10s of years old)asked 6 months ago
Array as value of OPC node to SiteWise Assetsasked 5 months ago
AWS - FTP Solutionasked a month ago
Is there a way to Connect a raspberry pi to a aws react app?asked 21 days ago
Which AWS solution is the closest to PI AF?asked 7 months ago
Is it possible to use IAM and Secure Token Service as the authentication solution for an application?asked 6 months ago
Is it possible for QBSolve to return an infeasible solution to the problem, even though matrix Q is guaranteed to be correct?Accepted Answerasked 4 months ago