Missing warehouse id/metadata for the system compute warehouse table

Danish1105 — Fri, 31 Oct 2025 14:53:42 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

Advika — Tue, 04 Nov 2025 14:19:45 GMT

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.

topic Missing warehouse id/metadata for the system compute warehouse table in Get Started Discussions

Missing warehouse id/metadata for the system compute warehouse table

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