Missing warehouse id/metadata for the system compute warehouse table

[Danish1105]

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.
  

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

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.

[Advika]

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.