Answer: COPY_HISTORY

The COPY_HISTORY table function (or the COPY_HISTORY view in ACCOUNT_USAGE schema) is specifically designed to track load activity from staged files into Snowflake tables. It provides detailed information about file names, load statuses, timestamps, and other metadata that allows users to verify whether a particular file has been previously loaded. The community discussion confirms this with 100% consensus on option A, and the provided SQL example demonstrates how to query COPY_HISTORY to check if a specific file (like 'orders_20250419.csv') has been loaded into a table. Other options are less suitable: B) DATA_TRANSFER_HISTORY tracks data movement between regions/clouds, not file loading; C) WAREHOUSE_LOAD_HISTORY monitors warehouse performance metrics; D) STAGE_STORAGE_USAGE_HISTORY tracks storage usage in stages, not file loading status.

Author: LeetQuiz Editorial Team