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?
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nexerSnow
5 months, 3 weeks agoLematthew31
5 months, 3 weeks agoyaho5
6 months, 2 weeks agotidz
9 months, 1 week agoDR369
9 months, 3 weeks ago