Data quality: Default schedule for data metric functions (Pending)¶

Data metric functions (DMFs) are associated with tables and views to run data quality checks on a regular schedule. This change introduces the concept of a default schedule, and behaves as follows:

Before the change:

You must modify a table or view to set a schedule before you can associate a DMF with the object. There is no default schedule.

If you run an ALTER <object> UNSET DATA_METRIC_SCHEDULE command, the DMF schedule is set to an empty string, which suspends all DMF evaluations on the table or view.

After the change:

Every table and view has a default schedule of one hour. All you need to do to run data quality checks at one-hour intervals is associate a DMF with an object. You can change the default at any time.

If you run an ALTER <object> UNSET DATA_METRIC_SCHEDULE command, the DMF schedule is reset to the default of one hour.

If you want to suspend all DMFs associated with an object, set the schedule to an empty string.

Ref: 2101