Skip to main content

Create Table

The syntax to be used for the Snowflake CREATE TABLE DDL. It enables the use of CREATE OR REPLACE and CREATE OR ALTER syntax options, when supported by the Snowflake environment.

The value is used as the statement prefix of the generated Snowflake table DDL. A blank value is treated as CREATE TABLE IF NOT EXISTS.

When to Change This Setting​

Keep the default CREATE TABLE IF NOT EXISTS for idempotent deployments that preserve existing tables. Use CREATE OR REPLACE when deployments should rebuild tables from the generated definition.

SettingInteraction
Add SQL CommentsAdds comment statements alongside the generated DDL
Output PathWhere the generated SnowDT DDL files are written

Notes​

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is CREATE TABLE IF NOT EXISTS.