.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"}'