Skip to main content

Insert Script With Table

When enabled, this setting ensures that the default insert script is retained and bundled together with the CREATE TABLE file. This is useful if you wish to keep the initial data insertion logic intact alongside the table structure.

For Hub, Link, Satellite, Point-In-Time and Bridge objects, the generated default merge/insert script is appended to the table's create script output when this setting is enabled; when disabled, the script is emitted into the post-deployment script instead. The same placement rule applies to the script outputs produced for Databricks and Fabric targets.

When to Change This Setting​

Keep the default N to have data-insertion logic collected in the post-deployment script, separated from the DDL. Enable it when each table's file should be self-contained: structure plus its default insert logic in one script.

Notes​

  • This setting is part of the Data Vault settings category.
  • The default value for this setting is N.