Data Superhero, Snowflake, Snowflake Data Cloud, Cost Optimisation, Performance Optimization.
of micro partitions. Basic characteristics of micro partitions: Max 16 MB of compressed data (50–500 MB uncompressed) iImmutable — update creates a new micropartition Snowflake keeps metadata about each micropartition in cloud service layer Divides tables horizontally Because of immutability the