Expectations

The expectations system table includes information about the expectations that have been added to the jobs that run within your organization.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.monitoring.expectations;

The system.monitoring.expectations table includes the following columns:

Column	Type	Description
action	string	The action to take when the expectation is triggered, e.g. warn, drop.
expectation_name	string	The name of the expectation.
job_id	string	The unique identifier of the job that the expectation exists in.
job_name	string	The name of the job that the expectation exists in.
triggered_today	bigint	The number of times the expectation has been triggered today (since midnight (UTC) time).
triggered_total	bigint	The number of times the expectation has been triggered since it was created.