databasesnowflake-cloud-data-platform

How to manually refresh a Snowflake Marketplace listing?

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!

Solution

  • https://docs.snowflake.com/en/sql-reference/functions/system_trigger_listing_refresh

    show listings;

    select system$trigger_listing_refresh('LISTING','LISTING_NAME');