Answer: ACCESS_HISTORY

The ACCESS_HISTORY view in Snowflake's Account Usage schema is specifically designed to track column lineage, showing how data flows from source columns to target columns during SQL write operations like INSERT, UPDATE, DELETE, and COPY commands. The community discussion unanimously supports this with 100% consensus on answer A, and multiple comments reference the official Snowflake documentation that confirms ACCESS_HISTORY is the correct view for column lineage tracking. The other options (LOAD_HISTORY, QUERY_HISTORY, COPY_HISTORY) are different Snowflake views that serve other purposes - LOAD_HISTORY tracks data loading operations, QUERY_HISTORY shows query execution details, and COPY_HISTORY specifically monitors COPY command executions, but none of these provide the comprehensive column lineage functionality that ACCESS_HISTORY offers.

Author: LeetQuiz Editorial Team