.alter 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 materialized-view MaterializedViewName policy partitioning ArrayOfPolicyObjects
Arguments
MaterializedViewName - Specify the name of the materialized view. ArrayOfPolicyObjects - An array with one or more policy objects defined.
Example
Change the policy at the materialized-view level:
.alter materialized-view MyMaterializedView policy partitioning '{"EffectiveDateTime":"2023-01-01"}'