The part of ACID which ensures that transactions running at the same time can't disturb each other and that the database is left consistent.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Isolation in context, with comparison tables and the common traps.
Terms in this definition
- ACID
Four promises a database transaction makes: atomicity, consistency, isolation and durability. Azure Cosmos DB honours them, with snapshot isolation, only inside one logical partition, using stored procedures, triggers or transactional batch.
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA.