what do you mean by "set file trigger for the location where the mv table writes and then create your job whenever anything will be written in the mv table your job will trigger." ? 

Isn't the file trigger for external location such as s3? It will work for snowflake foreign catalog?