---
title: "ETL Settings"
canonical: "https://docs.vaultspeed.com/space/VPD/3013050377/ETL%20Settings"
format: markdown
---
> Macro (toc)

In the **ETL Settings** tab, custom ETL Settings (i.e. modifiers to functions / SQL / tool code ) can be predefined. The properties that can be set are based upon the technology.

> 📝 This document describes the basic use of the screen.  More details on the different ETL options and examples can be found here: [https://vaultspeed.atlassian.net/wiki/spaces/VPD/pages/3012755484](https://vaultspeed.atlassian.net/wiki/spaces/VPD/pages/3012755484)

To take a look at the ETL settings, navigate to the **DDL/ETL Generation **menu and** **click on **ETL Settings**.

![image](media://0c62e2b9-f60a-49f4-a990-6aef411081fc)

# ETL Settings List

To create a new set of ETL Settings, click the ‘+ ETL Preset’ at the top right of the screen.  In the popup screen, enter a name for the setting, select the database type and the generation language.

![image](media://4344688f-b60b-4f0b-a1cd-1dc354794457)

A number of function/SQL/tool parameters can be set here, either by turning the option on or off, or by entering a custom text.  If you scroll to the bottom of the screen, an example of a function/procedure/tool script is shown, reflecting the parameters that were set:

![image](media://286fcf31-b367-46a7-9572-c1a265d8d15b)

![image](media://078316f5-e40c-468c-b0a4-6cfef41ef9c5)


Once you have done all the settings you like, click the ‘Create’ button to save the settings.

If you already have some presets created, you can always use the Actions menu items at the end of each record to make changes or remove them.  

# Apply ETL Settings

In the **Apply ETL Settings** submenu, the presets that you created can be applied to different layers/objects on you data vault.

![image](media://79f8ac6f-f992-4251-a169-9432d7f550e6)

In the drop-down boxes, select:

- Layer: the loading layer where you want to apply the setting to.  The different layers are:
  - Business_vault_layer: The loading logic for all business vault objects (except the ones created through VaultSpeed studio)
  - cdc_layer: The loading logic for all change data capture objects
  - delta_firewall_layer: The loading logic for the Delta Firewall Views
  - delta_layer: The loading logic for the Delta Tables
  - extraction_layer: The loading logic for the Extraction Layer
  - flow_management_control_layer: The loading logic on the FMC objects
  - foundation_layer: The loading logic for the Raw Data Vault Objects
  - initial_load_layer: The loading logic for the initial load objects
  - metadata_layer: The loading logic for the metadata objects per source
  - staging_layer: The loading logic for the staging layer
- Settings Preset: one of the settings you created in the previous step
- Data Vault: the data vault on which you want to apply the setting
- Source: The source where you want to apply the settings to.

> ℹ️ The Business vault or foundation layer are no longer distinct per source, so you can select the different object types here. (see below)

Click the ‘Apply ETL Preset’ button to actually apply the setting to the selected layer/objects.  The applied setting will now appear in the list below.

![image](media://0ef61436-52d7-4e1a-a9a1-a55924a51712)

> ⚠️ Only one preset can be active at the same time.  If there was a ETL setting applied before, it will be overwritten by the new one.

Selecting the **Foundation layer** or **Business Vault Layer** will replace the source dropdown with an Object Type one. It can be left empty to apply a setting to all objects, or to a specific type. This can be mixed so for example you can set a certain setting for all types, and a different one for only the HUBs or PITs.

![image](media://b485292f-158c-4e7c-ab40-3357d000eb92)

> 📝 More details and examples can be found here: [https://vaultspeed.atlassian.net/wiki/spaces/VPD/pages/3012755484](https://vaultspeed.atlassian.net/wiki/spaces/VPD/pages/3012755484)