Data Superhero, Snowflake, Snowflake Data Cloud, Cost Optimisation, Performance Optimization.
micro partitions are a management unit for DML operations. Micro partition metadata is used by the query optimizer to eliminate unneeded micro partitions. Those which contain irrelevant data for a given query.That should always be the number one goal when writing a query. Let’s not read what is not