Overview
This dashboard shows data freshness across the consumption_prd Unity Catalog. It displays which tables and client feeds have been recently updated, which are stale, and by how much — based on configurable per-domain SLA deadlines set in Eastern Time.
Data is polled on a schedule by a Databricks notebook and published as a JSON snapshot. The snapshot is loaded automatically when the page opens.
Freshness Status
Fresh
Data was updated today, or is within the acceptable multi-day SLA window (before the final delivery day).
Waiting
Data is on its final allowed day and delivery is due today, but the SLA deadline has not yet passed in Eastern Time.
Stale
Data has not been updated within the SLA window, or the deadline has passed without a refresh.
Missing
No ETL modification date is recorded for this feed. The table may not track data timestamps.
Controls
View
Switch between Flat (all tables as a list), By Schema (tables grouped by schema, default), and By Client Feed (grouped by client feed ID) layouts.
Search
Real-time text filter across table names, client names, business lines, feed names, and feed types. Filters feeds within each table, hiding tables entirely if no feeds match.
Freshness
Toggle chips to show only feeds with specific statuses. Multiple statuses can be selected at once; all are shown when none are selected.
Clients
Multi-select dropdown to show only feeds belonging to specific client organizations.
Business Line
Multi-select dropdown to scope to one or more business lines (e.g., acute, ambulatory).
Feed Type
Multi-select dropdown to show only feeds of a specific type.
Sort
Sort tables and groups by Stalest First (default — surfaces the most problematic data), Table Name (alphabetical), or Feed Count. Click an active sort button to reverse direction.
Table Cards
Click any table or group card to expand it and see per-feed detail. Each feed row shows: Feed ID, Client • Business Line • Feed Name • Feed Type, Last Updated timestamp, Age, SLA deadline, Record count, and Status badge.
The colored dots on collapsed table cards provide a quick at-a-glance view — one dot per feed, colored by its freshness status.
In By Schema and By Client Feed views, the top-level card must be expanded first to reveal the table or feed rows inside.
Loading Data
The latest snapshot is fetched automatically on page load. You can also load a local snapshot file:
- File input: Use the Load Local File section at the bottom of the page to select a
.json snapshot and click Submit.
- Drag and drop: Drag any
.json snapshot file anywhere onto the page to load it immediately.