Missing warehouse id/metadata for the system compute warehouse table

Danish1105
New Contributor II

‎10-31-2025 07:53 AM

I ran the following queries for a specific warehouse_id = '54a93d2138433216'

 

SELECT * FROM system.billing.usage WHERE usage_metadata.warehouse_id = '54a93d2138433216';
SELECT * FROM system.compute.warehouse_events WHERE warehouse_id = '54a93d2138433216';
SELECT * FROM system.compute.warehouses WHERE warehouse_id = '54a93d2138433216';
 
Observations:
  • Billing usage and warehouse events tables return valid records for this warehouse ID.
    Danish1105_0-1761921778719.pngDanish1105_1-1761921803763.png

     

 

  • Warehouse table (system.compute.warehouses) returns no row at all, not even with a deleted timestamp.
    Danish1105_2-1761921831376.png

     

Even if the warehouse is deleted, I expected the metadata table to retain a row with a deleted timestamp or status. Is it a known behavior that deleted warehouses are fully purged from system.compute.warehouses? I would appreciate any explanation, reasoning, or confirmation from others who have observed similar behavior.

Labels:
0 Kudos

Advika
Community Manager
Community Manager

‎11-04-2025 06:19 AM

Hello @Danish1105!

This post duplicates a recent post you shared. A response has already been provided there. Please continue the discussion in that thread to keep the conversation organized.

0 Kudos