Missing warehouse id/metadata for the system compute warehouse table

Danish11052000
Contributor

‎11-03-2025 02:06 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.
    Danish11052000_0-1762164373471.png

     

    Danish11052000_1-1762164374050.png

     

     

 

  • Warehouse table (system.compute.warehouses) returns no row at all, not even with a deleted timestamp.
    Danish11052000_2-1762164373505.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.

0 Kudos