page129
112
Figure 4-2.
Metadata query result resolution
For Snowflake native tables, traditional indexes are not supported; therefore, index
maintenance is no longer an issue. Note that hybrid tables and/or Unistore support
traditional indexes and referential integrity, which is out of scope for this book but a
point to remember for the future.
Immutable Micro-partitions
Micro-partition immutability offers many great benefits with few downsides. Figure 4-3
illustrates the creation of two new micro-partitions where DML activity has modified the
“EMEA” contents of two micro-partitions for an imaginary table.
Figure 4-3.
Micro-partition retention
Dependent upon table type, the retained micro-partitions may be saved for the
duration of your Time Travel setting and seven-day Fail-Safe period before being
permanently and irretrievably removed. You can find more information on table types,
permissible Time Travel settings, and Fail-Safe periods at
https://docs.snowflake.
com/en/user-guide/tables-temp-transient#comparison-of-table-types
.
ChaPTer 4
MiCro-ParTiTionS