I have a data listing in the Snowflake Marketplace being Auto-Fulfilled to other regions. Currently, my listing is set to refresh on a weekly basis. But sometimes I need to do a refresh in the middle of the week.
My current approach is to: change the schedule to be daily, wait for the refresh, and then set as weekly again.
How can I avoid having to do all that by doing a manual refresh?
Additionally, the underlying data usually only changes once a week. If I set up the schedule as daily, will I get charged every day or just when the data actually changes?
Thanks!
https://docs.snowflake.com/en/sql-reference/functions/system_trigger_listing_refresh
show listings;
select system$trigger_listing_refresh('LISTING','LISTING_NAME');