Skip to main content
Orphaned resources · Low severity

Orphaned SQL Warehouse (No Queries in 30 Days)

A warehouse with no queries is configuration that still holds a size, an auto-stop setting and an access list, and it will start billing the moment anything touches it.

Sign inExplore the playground

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

3clouds covered
Lowseverity
Savingswhere it shows up
Manualfix, steps written out

AWSAzureGoogle CloudDatabricks

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, Azure and Google Cloud, with read-only access to the account.

02

Explain

Every finding says exactly what to change: Delete the SQL warehouse with no queries. 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
Databricks SQL Warehouse on AWS, Databricks SQL Warehouse on Azure, Databricks SQL Warehouse on Google Cloud
The fix, by hand on AWS
  1. Confirm the warehouse is no longer needed (check recent query history and any dashboards/BI tools pointing at it).
  2. Delete the warehouse, or stop it and tighten its auto-stop if it may be needed later.
  3. Repoint any dependent dashboards or queries to an active warehouse first.

These are the steps the finding carries in the product.

Category
Orphaned resources. Resources no longer attached to anything that needs them, such as unattached volumes and unassigned IPs.
Where it appears
The Savings tab of Recommendations, with every affected resource listed.
Rule IDs
RC-2231 RC-2331 RC-2431
Full reference

Orphaned SQL Warehouse

Related checks

SQL Warehouse Auto-Stop Disabled/ExcessiveAWS, Azure, Google CloudMissing Cost-Allocation TagsAWS, Azure, Google CloudAzure Duplicate Flow LoggingAzureAzure Connection Monitor with No Surviving SourceAzureAzure Flow Log on a Gateway SubnetAzureAzure Recovery Vault OrphanAzure

See the orphaned 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.

Start freeExplore the playground

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·