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
Sign in to Snowsight.
Select Monitoring » Dynamic Tables.
Find your dynamic table in the list and then select
» Refresh Manually.