COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ90

VerifiedPerformance Optimization, Querying & Transformation

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?

Explanation

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.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!