Altering a materialized view

Altering the properties of a materialized view with the ALTER MATERIALIZED VIEW command.

A materialized view are created with the default table properties. Use the ALTER MATERIALIZED VIEW command alter the view's properties. Specify updated properties and values in a WITH clause. Materialized views do not perform repair, so properties regarding repair are invalid.

Procedure

Alter a materialized view to change the caching properties.
ALTER MATERIALIZED VIEW cycling.cyclist_by_birthday 
WITH caching = {'keys' : 'NONE', 'rows_per_partition' : '15' };