Materialized view sub-database replication

A machine comprising:

• at least one processor;
• and
• at least one memory storing instructions that, when executed by the at least one processor, cause the machine to perform operations comprising:
• receiving, by one or more processors, from a database user, an identification of a column in a data table for filtering;
• clustering, by the one or more processors, the data table based on the column to generate one or more micro-partitions sorted in the column;
• accessing, by the one or more processors, metadata for the one or more micro-partitions of the data table, the metadata indicating a minimum value and a maximum value for the column in each micro-partition;
• performing, by the one or more processors, file-level filtering of the one or more micro-partitions based on the metadata without opening the one or more micro-partitions;
• generating, by the one or more processors, a replication policy based on the file-level filtering;
• and
• performing, by the one or more processors, sub-database replication of filtered micro-partitions from a first database to a second database in a different region using the replication policy.

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

• receiving, by one or more processors, from a database user, an identification of a column in a data table for filtering;
• clustering, by the one or more processors, the data table based on the column to generate one or more micro-partitions sorted in the column;
• accessing, by the one or more processors, metadata for the one or more micro-partitions of the data table, the metadata indicating a minimum value and a maximum value for the column in each micro-partition;
• performing, by the one or more processors, file-level filtering of the one or more micro-partitions based on the metadata without opening the one or more micro-partitions;
• generating, by the one or more processors, a replication policy based on the file-level filtering;
• and
• performing, by the one or more processors, sub-database replication of filtered micro-partitions from a first database to a second database in a different region using the replication policy.