Get Warehouse Statistics

Retrieves statistical data about a warehouse's usage and resources over time. Statistics are aggregated hourly when changes occur.

We lazily create a new statistics entry every hour, in between hours, the existing entry is being updated. If there's a change at created_at + 1 hour, a new entry is created. If there's been no change, no new entry is created, meaning there may be gaps.

Example:

• 00:16:32: warehouse created:
  • timestamp: 01:00:00, created_at: 00:16:32, updated_at: null, 0 tables, 0 views
• 00:30:00: table created:
  • timestamp: 01:00:00, created_at: 00:16:32, updated_at: 00:30:00, 1 table, 0 views
• 00:45:00: view created:
  • timestamp: 01:00:00, created_at: 00:16:32, updated_at: 00:45:00, 1 table, 1 view
• 01:00:36: table deleted:
  • timestamp: 02:00:00, created_at: 01:00:36, updated_at: null, 0 tables, 1 view
  • timestamp: 01:00:00, created_at: 00:16:32, updated_at: 00:45:00, 1 table, 1 view