Hourly snapshots of your site map racks and positions, joined to the miners sitting in each slot.
Part of the Foreman Intelligence Data Dictionary. Model: customer_access. Generated from the live Looker model on 2026-09-04.
Contents
Explores in this group
Site Map Data site_map_history
Looker description: Hourly snapshot of site maps data
Hourly snapshots of your Foreman site map: which racks exist, how big they are, and which miner sits in each position. The miner in each slot is joined to both its current and its hourly telemetry, so you can build heat maps and rack-level rollups as they looked at any hour in the past.
| Grain | One row per rack position per hour |
| Time field | Timestamp (1h) |
| Best for |
|
Example questions
- What was the average temperature per rack at 3 pm yesterday?
- Which racks have empty or disabled positions?
- How much power did each row draw per hour last week?
Views in this explore: Client Power Cost, Coin Hash Price, Miner Data, Miner Details (Current), Miner Metrics Hourly (Historical), Site Map Rack Locations (Historical), Site Map Racks (Historical)
Fields by view
Each explore is built from one or more views. A view is a set of related fields, and the tables below list every visible field in each view this article owns. Dimensions are attributes you can group and filter by. Measures are aggregates that add up, average, or count across the rows you select.
Site Map Racks (Historical)
Hourly snapshots of the racks on your site map: their names, sizes, and which site map group and client they belong to.
Used by: Site Map Data
Dimensions
| Field | Type | What it means |
|---|---|---|
| Rack ID | Number | Numeric ID of the rack. |
| Rack Name | Text | Name of the rack on the site map. |
| Rack Size | Number | Number of positions in the rack. |
| Site Map Client ID | Number | Numeric ID of the client whose site map this is. |
| Site Map Client Name | Text | Name of that client. |
| Site Map Group ID | Number | ID of the site map group the rack belongs to, such as a building or container. |
| Site Map Group Name | Text | Name of that site map group. |
| Timestamp (1h) | Hour | Time of the hourly snapshot. |
Site Map Rack Locations (Historical)
Hourly snapshots of each position in each rack and the miner sitting in it. An empty position has no Miner ID. Join through Miner ID to the miner views for telemetry.
Used by: Site Map Data
Dimensions
| Field | Type | What it means |
|---|---|---|
| Disabled (Yes / No) | Yes / No | Yes if the position has been disabled on the site map, so it is not expected to hold a miner. |
| Index | Number | Position index within the rack. |
| Miner Client ID | Number | Numeric ID of the client that owns the miner in the position. |
| Miner Client Name | Text | Name of the client that owns the miner in the position. |
| Miner ID | Number | Foreman ID of the miner in the position. Blank when the position is empty. |
| Rack ID | Text | ID of the rack the position belongs to. |
| Rack Name | Text | Name of that rack. |
| Row | Number | Row within the rack. |
| Timestamp (1h) | Hour | Time of the hourly snapshot. |
Shared views documented elsewhere
These views are joined into explores in this group but are documented in another article so the definitions live in one place.
- Client Power Cost (used by Site Map Data)
- Coin Hash Price (used by Site Map Data)
- Miner Data (used by Site Map Data)
- Miner Details (Current) (used by Site Map Data)
- Miner Metrics Hourly (Historical) (used by Site Map Data)
Comments
0 comments
Please sign in to leave a comment.