Missing warehouse id/metadata for the system compute warehouse table

Danish11052000 — Mon, 03 Nov 2025 10:06:36 GMT

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.

Re: Missing warehouse id/metadata for the system compute warehouse table

MuthuLakshmi — Tue, 04 Nov 2025 11:51:52 GMT

@Danish11052000
The issue can happen when the warehouse created is very old (let's say last year), then you may not see the details in system table.
If they were deleted before the table was created, you'll not see it.

topic Missing warehouse id/metadata for the system compute warehouse table in Data Engineering

Missing warehouse id/metadata for the system compute warehouse table

Re: Missing warehouse id/metadata for the system compute warehouse table