Skip to main content

ENTITY_HISTORY Namespace

The ENTITY_HISTORY namespace contains historical snapshots for every table in the ENTITY_METADATA namespace. Each table in the ENTITY_HISTORY namespace:

  • Mirrors the corresponding table in ENTITY_METADATA
  • Adds timestamp columns for change tracking and time-series analysis

Key snapshot columns:

  • snapshot_timestamp: Timestamp when this snapshot was captured.
  • snapshot_date: Date when this snapshot was captured. This column is used for partitioning and date filters.

Use these examples as a starting point for building time-series analyses, change-tracking reports, and audit queries on top of the ENTITY_HISTORY namespace.

Browse ENTITY_HISTORY example queries grouped by category. Select a pattern to see the SQL and key columns used.

8of 8 results
Active assets by day
Time-series
Certification status trend over time
Time-series
Changes made by a specific user
Audit
Latest snapshot for a specific asset
Point-in-time
Metadata at a change freeze cutoff
Audit
State on a specific date
Point-in-time
Track description changes for assets
Change tracking
Track owner changes for assets
Change tracking
🔌

Select an item

Choose an item from the list to view details