What considerations should a Data Engineer make when leveraging the TASK_HISTORY table function?
TASK_HISTORY
Access to task history requires task ownership or sufficient monitoring/operation privileges, such as MONITOR or OPERATE on the task, global MONITOR EXECUTION, or ACCOUNTADMIN. TASK_HISTORY applies its task-name, time-range, and result-limit arguments before SQL WHERE and LIMIT clauses.
Community Discussion