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.
