Account
Skip to main content

Use Script Fragments

Generates separate SQL script fragments per target table type (for example Hub, Link, Satellite). Recommended when using Use SQL Scripting with Data Vault models.

With Use SQL Scripting enabled and this setting disabled, the Data Vault loads are combined into one full load script. With both enabled, each Data Vault target keeps its own script with its own BEGIN ... END block, and the generated task calls each of these scripts.

The setting also changes the file names of the satellite and reference scripts. With the setting disabled, their full load scripts carry a _Full suffix. With it enabled, the suffix is dropped.

When to Change This Setting​

The setting is meant to be used together with Use SQL Scripting. Enable both when each Data Vault target should load from its own script. With Use SQL Scripting enabled, keep the default N to keep the Data Vault loads in one full load script.

SettingInteraction
Use SQL ScriptingFragments replace the single full load script only when SQL scripting is enabled

Notes​

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