Data Engineering, Data Analytics, Database, Snowflake, Software Engineering.
will see the consistent SI of the database as of the time the transaction started. SI is implemented on top of multi-version concurrency control (MVCC), which means a copy of every change on a desired object (table) is preserved for some time. Making copies of every change is an obvious choice