Data Superhero, Snowflake, Snowflake Data Cloud, Cost Optimisation, Performance Optimization.
pruning, introducing more filters, optimizing joins, rewriting the query or splitting it into multiple steps. Partition Pruning Snowflake uses the concept of micro partitions for holding up the data. It’s a storage unit, physical files holding the logical table data. Each table contains thousands