Add Sql Comments
Enable this option to include user-defined metadata as SQL comments in your CREATE TABLE scripts.
When enabled, the generated Snowflake DDL includes COMMENT IF EXISTS ON TABLE and COMMENT IF EXISTS ON COLUMN statements populated from the Description (or Comments) metadata of the object and its columns.
When to Change This Setting
Enable it to carry the model's descriptions into Snowflake, where they surface as object and column comments for consumers of the database.
Related Settings
| Setting | Interaction |
|---|---|
| Create Table | The DDL the comment statements accompany |
Notes
- This setting is part of the Snowflake settings category.
- The default value for this setting is
N.