Manually refresh dynamic tables¶

If you want your dynamic table to include the latest data without waiting for the next scheduled refresh, you can use manual refresh.

This is useful for large target lags or one-time refreshes. For example, if a dynamic table is configured with a large target lag and its next refresh is hours away, a manual refresh ensures up-to-date data.

Manual refreshes are never skipped but they can cause scheduled refreshes to skip, especially if you perform frequent manual refreshes on a dynamic table. Doing so can prevent downstream dynamic tables from refreshing. For this reason, Snowflake recommends that you avoid frequently performing manual refreshes on a dynamic table with downstream dynamic tables that are expected to refresh according to target lag.

You can manually refresh a dynamic table using the ALTER DYNAMIC TABLE … REFRESH command or using Snowsight.

ALTER DYNAMIC TABLE my_dynamic_table REFRESH