Incremental refresh of a materialized view

A system comprising:

• at least one hardware processor;
• and
• at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
• providing a source table including a set of micro-partitions;
• generating a materialized view based on the source table, the materialized view combining information in the set of micro-partitions in the source table into a single micro-partition in the materialized view;
• identifying an update to the source table not reflected in the materialized view by merging the source table and the materialized view, the update including a modification to one or more of micro-partitions in the set of micro-partitions in the source table;
• and
• applying the update to the materialized view to generate an updated materialized view.

A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

• providing a source table including a set of micro-partitions;
• generating a materialized view based on the source table, the materialized view combining information in the set of micro-partitions in the source table into a single micro-partition in the materialized view;
• identifying an update to the source table not reflected in the materialized view by merging the source table and the materialized view, the update including a modification to one or more of micro-partitions in the set of micro-partitions in the source table;
• and
• applying the update to the materialized view to generate an updated materialized view.