I am having a similar challenge with data not reflecting on the snowflake side for a external table although there is data within the source file. Did you manage to fix your issue?