The information schema is a Snowflake schema present in every database. Its views expose object metadata, while its table functions provide historical and usage data for operational checks. section 2.5
Use information-schema objects to verify pipeline behavior:
- Inspect task executions, including query text, state, errors, return values, and execution timestamps. section 2.5
- Inspect recent file loads, including filenames, target tables, load times, row counts, and load status. section 3.1.5
Listing 2.4 Viewing previous and scheduled task executions
select * from table(information_schema.task_history()) order by scheduled_time desc;
Query TASK_HISTORY() to review previous and scheduled task executions, ordered by scheduled time. section 2.5
select * from information_schema.load_history where schema_name = 'EXTERNAL_ORDERS' and table_name = 'ORDERS_BISTRO_STG' order by last_load_time desc;
Query LOAD_HISTORY to verify files loaded into a staging table and inspect their latest statuses. section 3.1.5
