When you create your Materialized View, you can use a special "AUTO" attribute to signal you want that MV to auto refresh.
Here are some docs: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh-sql-command.html
Hopefully that helps!