.alter-merge materialized view partitioning policy
Change a materialized view partitioning policy. The partitioning policy defines if and how extents (data shards) should be partitioned for a specific table or a materialized view. The command requires DatabaseAdmin permissions.
Syntax
.alter-merge materialized-view MaterializedViewName policy partitioning ArrayOfPolicyObjects
Arguments
MaterializedViewName - Specify the name of the materialized view. ArrayOfPolicyObjects - An array with one or more JSON policy objects.
Example
Change the policy at the materialized view level:
.alter-merge materialized-view MyMaterializeView policy partitioning '{"EffectiveDateTime":"2023-01-01"}'