A Developer has scheduled a dynamic table for incremental refresh, but it is performing a full refresh instead.
Which query operator, when used, causes a full refresh rather than the scheduled incremental refresh?
Snowflake supports incremental refresh for DISTINCT, standard GROUP BY, and UNION ALL. A general LATERAL JOIN is not supported for incremental refresh, so a dynamic table using it falls back to a full refresh. Limited LATERAL FLATTEN usage is a separate exception.
Community Discussion