If a source table is updated while cloning is in progress, what data will be included in the cloned table?
If a source table is updated while cloning is in progress, what data will be included in the cloned table?
Cloning considerations | Snowflake Documentation - During this period, DML transactions can alter the data in a source table. Subsequently, Snowflake attempts to clone the table data as it existed when the operation began.
Please, disregard mt previous reply from above. Take in consideration the below presentation: I am reanalyzing. Link is: https://docs.snowflake.com/en/user-guide/object-clone Cloning and foreign key constraints Cloning operations require time to complete, particularly for large tables. During this period, DML transactions can alter the data in a source table. Subsequently, Snowflake attempts to clone the table data as it existed when the operation began. My comment: the key word in the message from SNOW FLAKE link is the word "operation". Cloning is the "operation". Hence, it seems that in the second phrase, "when the operation began" is referring to "when the cloning operation began". Hence, Snowflake tries (attempts) to clone without the DML changes occurring during cloning. But, will Snowflake do it? Apparently YES, if we take in consdieration the proposed answer as C.