Use case
An upstream system writes a daily extract into a container in Azure Blob Storage, and the warehouse load runs against whatever is there at 04:00.
The load succeeds on stale files, because a loader reading a folder cannot tell the difference between today’s extract and yesterday’s. The failure surfaces as numbers that look plausible and are a day old.
month endThe discrepancy is found against a period nobody can re-run.
An account, a container and a SAS token scoped to the one prefix we list. The full posture.
Nightly warehouse extract
If the key expires, that’s Check broken, never Missed - broken access is its own alert, and it says whose job it is to fix.
Set it up in a sentence:
“The warehouse extract lands in Azure Blob under exports/daily by 3:30am, give it 30 minutes.”
Create monitor