Which system-defined, read-only view displays information on column lineage that specifies how data flows from source to target in a SQL write operation?
Which system-defined, read-only view displays information on column lineage that specifies how data flows from source to target in a SQL write operation?
The system-defined, read-only view that displays information on column lineage specifying how data flows from source to target in a SQL write operation is ACCESS_HISTORY. This view extends to specify how data is transferred from a source column to a target column in write operations such as INSERT, UPDATE, and DELETE, tracking the data through all subsequent table objects referencing the source columns.
it's correct see: https://docs.snowflake.com/en/user-guide/access-history
Access History in Snowflake refers to when the user query reads data and when the SQL statement performs a data write operation, such as INSERT, UPDATE, and DELETE along with variations of the COPY command, from the source data object to the target data object. The user access history can be found by querying the Account Usage ACCESS_HISTORY view.
It's A "Column lineage Column lineage (i.e. access history for columns) extends the Account Usage ACCESS_HISTORY view to specify how data flows from the source column to the target column in a write operation. Snowflake tracks the data from the source columns through all subsequent table objects that reference data from the source columns (e.g. INSERT, MERGE, CTAS) provided that objects in the lineage chain are not dropped. Snowflake makes column lineage accessible by enhancing the objects_modified column in the ACCESS_HISTORY view." --> https://docs.snowflake.com/en/user-guide/access-history
https://docs.snowflake.com/en/user-guide/access-history A
Answer A