Snowflake: History

Any change in entity bumps the version and a new version of the entry is saved into the relevant storage location’s history table. This functionality is enabled by default for tables. To disable it, add history: DISABLED as a top-level property of your table schema definition.

Database structure

History tables are created with the same name under a different database schema with suffix _HISTORY. I.e. if the table PET_INVENTORY is under PET_STORE database schema its history will be stored in PET_INVENTORY table under PET_STORE_HISTORY database schema.