MATERIALZIED VIEW TRIGGER ON UPDATE with external table as upstream table

tana_sakakimiya
Contributor

goal: implement event driven architecture without trigger on file arrival

I would like to know whether materialzied view can update itself when its source table which is external table updated.

given that the source external table referencing data in delta format on S3 with this delta.
enableChangeDataFeed= true
delta.enableRowTracking = true
delta.enableDeletionVectors = true

and i configure the materialized view to trigger on update