Snowflake CREATE DYNAMIC TABLE SQL Reference (2026)

Official Snowflake SQL reference for CREATE DYNAMIC TABLE command.

Key facts surfaced (2026-05-19):

• TARGET_LAG: Required when SCHEDULER=ENABLE; e.g., '5 minutes'. Minimum 60 seconds. Use DOWNSTREAM for refresh-on-demand.
• WAREHOUSE: Required; designates compute for refresh operations.
• REFRESH_MODE: AUTO (default), FULL, or INCREMENTAL.
• INITIALIZE: ON_CREATE or ON_SCHEDULE for initial population.
• Supports standard creation, restore from backup, cloning, and Iceberg table variants.
• Curriculum reference: composable CDP equivalent of AEP CTAS with scheduled refresh (Module 4).