---
title: "Create data set"
slug: "create-data-set"
tags: ["Task", "Data Modeling Studio", "DMS"]
updated: 2026-03-20T11:26:23Z
published: 2026-03-20T17:44:45Z
canonical: "docs.staedean.com/create-data-set"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create data set

In Data Modeling Studio, a data set defines the data to be exported. Use a data set to define the data to be exported by a data model.

On creation of a data set, at least, define:

- The relevant table.
- The data selection type.
- If system fields or date/time fields are added automatically to the data set.

### Steps

1. Go to **Data modeling studio** > **Data modeling studio** > **Data sets**.
2. Click **New**.
3. In the **Table name** field, enter or select a value.
4. The default description is the description of the table. You can change the description as desired.

In the **Description** field, type a value.
5. For grouping purposes, you can assign a free-definable group 'tag' to a data set.

In the **Group** field, type a value.
6. Define how the data, as defined by the data set, is exported when using the default group or an export group:

In the **Data selection** field, select an option.
  - **All data**: All records are exported.
  - **Change tracking**: Change tracking is added to the SQL table. Change tracking identifies which records are created, updated, or deleted. Only the created, updated, or deleted records are exported.
  - **Timestamp**: Identifies the records that are created or updated since the latest export date/time. Only the created or updated records are exported.
7. You can add the table system fields to the target database. On export, the data of these system fields is also exported.

These system fields are added to the applicable table in the target database:

In the **Add system fields** field, select the desired option: '**Yes**' or '**No**'.

> [!NOTE]
> **Note**
> 
> If you add system fields to the target database, these fields:
> 
> - Are not shown in the fields section of the data set.
> - Get a prefix in the target database as defined by the **Entity system fields prefix** parameter of the **Data modeling studio parameters**. If no value is defined in this parameter, no prefix is added.
  - **RecId**
  - **RecVersion**
  - **CreatedDateTime**
  - **ModifiedDateTime**
  - **CreatedBy**
  - **ModifiedBy**
  - **DataAreaId**
  - **Partition**
  - **ExecutionId (DMS-specific)**
  - **SyncStartDateTime (DMS-specific)**
8. You can add the table date/time fields to the target database. On export, the data of these date/time fields is also exported.

Also, to the target database, additional fields are added to store the time zone. On export, time zone calculations are applied to store the right time in the target data base time zone.

In the **Add date and time fields** field, select the desired option: '**Yes**' or '**No**'.

> [!NOTE]
> **Note**
> 
> If you add date/time fields to the target database, these fields are not shown in the fields section of the data set.

> [!NOTE]
> **Notes**
> 
> If you create a data set, the data set identification is composed in this way: [Prefix][Table name][Suffix].
> 
> - **Prefix**: If on the **Date modeling studio parameters**, the **Entity prefix** field is filled, this field value is added as prefix to the data set identification. If no prefix is defined, no prefix is added.
> - **Table name**: The name of the table that is defined for the data set.
> - **Suffix**: This fixed suffix is added to each data set identification: DataEntity.
> 
> **Example**: If the entity prefix is 'CDP' and you create a data set for the SalesTable, the data set identification is: CDPSalesTableDataEntity.

## Related

- [Set up data sets](/set-up-data-sets.md)