@tana_sakakimiya Yes you can alter the view to refresh when the source table refreshes.
This feature is in beta now and you might have to reach out to a Databricks Support to enable the feature in your workspace.

This is the syntax for it. 

%sql


ALTER MATERIALIZED VIEW uc.sales.gold.mv_orders_agg
TRIGGER ON UPDATE AT MOST EVERY INTERVAL 1 MINUTE;