Manually refresh dynamic tables¶

To get the latest data, manually refresh a dynamic table before its next scheduled refresh. This is useful for large target lags or one-time freshness needs. 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