-- Sample only: audit summary by run window
SELECT
    CAST(LoadDtmUtc AS DATE) AS LoadDate,
    COUNT(*) AS RowCount,
    MIN(LoadDtmUtc) AS FirstLoadUtc,
    MAX(LoadDtmUtc) AS LastLoadUtc
FROM dbo.Stg_SourceRaw
WHERE LoadDtmUtc >= DATEADD(DAY, -7, SYSUTCDATETIME())
GROUP BY CAST(LoadDtmUtc AS DATE)
ORDER BY LoadDate DESC;