When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?
A . All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
B . Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
C . Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
D . All rows loaded using a specific COPY statement will have the same timestamp value.

View Answer

Answer: D

Explanation:

According to the Snowflake documentation, when loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP(), the default value is evaluated once per COPY statement, not once per row. Therefore, all rows loaded using a specific COPY statement will have the same timestamp value. This behavior ensures that the timestamp value reflects the time when the data was loaded into the table, not when the data was read from the source or created in the source.

Reference: Snowflake Documentation: Loading Data into Tables with Default Values

Snowflake Documentation: COPY INTO table