Skip to main content
Idle resources · Medium severity

Idle Timestream Database, No Queries

Timestream bills for stored data in both memory and magnetic tiers whether or not any query reads it, and memory-tier storage is the expensive one.

Free to start. No card. The playground just needs your work email.

AWSprovider
Mediumseverity
Savingswhere it shows up
Manualfix, steps written out

AWS

Found, explained, handed over.

Findings with a dollar figure attached, idle, oversized, orphaned, unscheduled and undiscounted spend.

01

Detect

ZopNight checks this automatically across AWS, with read-only access to the account.

02

Explain

Every finding says exactly what to change: Delete the idle Timestream database. Where the saving can be proven it is priced; where it cannot, the finding says so.

03

Fix

The finding opens with the fix already written out, step by step, so it is one ticket, not an investigation.

Applies to
Timestream Tables on AWS
The fix, by hand
  1. Confirm zero ingest + zero query activity over the last 7+ days (CloudWatch: SystemErrors / UserErrors / SuccessfulRequestLatency).
  2. Export historical data to S3 via UNLOAD or scheduled query if you may need rehydration.
  3. Open Timestream → Databases → select → delete each table → delete the database.
  4. Type the database name to confirm.
  5. Validate billing drop 24h later.

These are the steps the finding carries in the product.

Category
Idle resources. Resources running but doing no useful work: zero invocations, no connections, no traffic.
Where it appears
The Savings tab of Recommendations, with every affected resource listed.
Rule ID
RC-194
Full reference

Idle Timestream Database -- No Queries

Related checks

See the idle resources in your account.

Connect a read-only role and the first pass runs on your own estate. This check, and the rest of the catalogue, with it.

Prefer to talk it through first? Book 20 minutes with the team.

  • $30M+annualised cloud spend under management
  • 550K+resources tracked since launch
  • 20-60%off the bill in the first month
  • SOC 2Type II report, plus ISO 27001

Figures published on zop.dev.

Multi-cloud automation· Production-ready in 30 min· SOC 2 · ISO 27001· 20–60% off the bill, first month· 4 platforms · 1 console· Multi-cloud automation· Production-ready in 30 min· SOC 2 · ISO 27001· 20–60% off the bill, first month· 4 platforms · 1 console·