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