The following options and parameters are available for creating and configuring dynamic tables in Snowflake projects.
Dynamic tables properties
Naming and case-sensitivity
All SqlDBM objects must have a unique physical name (in physical project types), taking the schema into account. The logical name is used for metadata and descriptive purposes. See Snowflake Tables for additional details.
Indexes and constraints
Primary keys, Foreign keys and Alternative Keys are not supported for Dynamic tables. Only Clustering keys are supported.
Options
Specific options for Dynamic tables are described in this article. For shared options with tables, see Snowflake Tables.
Target Lag
Dynamic table refresh is triggered by the data’s target lag, which determines how outdated it can be. A fixed target lag can be set, or it can be set as DOWNSTREAM, making its refresh timing depend on other dynamic tables that depend on it.
See more https://docs.snowflake.com/en/user-guide/dynamic-tables-target-lag
Warehouse
Specifies the name of the warehouse that provides the compute resources for refreshing the dynamic table.
Refresh mode
Dynamic tables support two refresh modes: incremental and full. The refresh mode can either be set to AUTO or set explicitly to any of the available options.
See more: https://docs.snowflake.com/en/user-guide/dynamic-tables-refresh#label-dynamic-tables-initialization
Initialize
Introduces initialization, or in other words, the initial data population when creating a dynamic table. When the initial refresh occurs can be specified.
See more: https://docs.snowflake.com/en/user-guide/dynamic-tables-refresh#label-dynamic-tables-initialization